---------------------------------------------------------------------------

Copyright (c) 1994-7 Regents of the University of California

Permission to use, copy, modify, and distribute this software and its

documentation for any purpose, without fee, and without a written agreement

is hereby granted, provided that the above copyright notice and this

paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR

DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING

LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS

DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE

POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,

INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY

AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS

ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO

PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

---------------------------------------------------------------------------

PGACCESS 0.96 9 March 1999

================================

I dedicate this program to my little daughters Ana-Maria and Emilia and to my

wife for their understanding. I hope they will forgive me for spending so many

time far from them.

1.Why PgAccess ?

First of all because PostgreSQL lacks a graphical interface where you

can manage your tables, edit them, define queries, sequences and

functions.

2.How to INSTALL ?

You will need Tcl/Tk package, I am using now Tcl 7.6 and Tk 4.2.

PgAccess is running fine also on Tcl/Tk 8.0

Also, you will need the PostgreSQL to Tcl interface library, lined as a

Tcl/Tk 'load'-able module. It is called libpgtcl and the source is

located in the PostgreSQL directory /src/interfaces/libpgtcl.

Specifically, you will need a libpgtcl library that is 'load'-able from

Tcl/Tk. This is technically different from an ordinary PostgreSQL

loadable object file, because libpgtcl is a collection of object files.

Under Linux, this is called libpgtcl.so. You will find a pre-compiled

copy of it for Linux i386 systems at : http://www.flex.ro/pgaccess.

Just copy libpgtcl.so into your system library directory /usr/lib or

/lib and go for it.

Under Windows, copy libpgtcl.dll and libpq.dll into C:\WINDOWS\SYSTEM directory.

Make sure you have Tcl/Tk at least version 8.0.0 for Microsoft Windows 95 & NT.

PgAccess has been checked with Tcl/Tk 8.0.4 version on Windows95 and Windows98

platforms.

Tcl/Tk 8.0.4 for Windows95 & NT can be downloaded from

ftp://ftp.scriptics.com/pub/tcl/tcl8_0/tcl804.exe

It is 1833712 bytes long.

3.How to run it?

You run it with the command:

wish -f pgaccess.tcl [database]

[database] is optional.

Another way of loading the PostgreSQL library is running it with pgwish.

It's a wish compiled with libpgtcl library so it could understand the

commands for working with PostgreSQL. For this, remove the line "load

libpgtcl.so" from the source. If your operating system has a different

library name or location, change the 'load libpgtcl.so' line in the

pgaccess.tcl file.

4.What does it now ?

- Opens any database on a specified host at the specified port, username and password

- Perform vacuum command.

- Saves preferences in ~/.pgaccessrc file

Tables

- opening multiple tables for viewing, max n records (configurable)

- column resizing by dragging the vertical grid lines

- text will wrap in cells now

- dynamic row height when editing

- table layout saved for every table

- import/export to external files (SDF,CSV)

- filter capabilities ,enter filter like price>3.14

- sort order capabilities ,enter manually the sort field(s)

- editing in place, double click the text you want to change

- record deleting , point the record, press Del key

- adding new records ,save new row with right-button-click on table for the moment

- table generator assistant

- table renaming and deleting (dropping)

- table information retrieving : owner, field information, indexes

Queries

- define, edit and store "user defined queries"

- save view layout

- can store queries as views

- execution of queries with optional user input parameters ( select * from invoices where year=[parameter "Year of selection"] )

- viewing of select type queries result

- running action queries (insert, update, delete)

- visual query builder with drag & drop support, table aliasing

Sequences

- define

- inspect

- delete

Views

- defining them saving queries as views

- view them , with filtering and sorting capabilities

- design views

- delete them

Functions

- define , inspect , delete

Reports

- simple reports from a table (beta stage)

- change font,size and style of fields and labels

- load and save reports from the database

- table previews, sample postscript print

Forms

- open user defined forms

- form design module available

- query widget allowing access to a record set

Scripts

- define, modify and call user defined scripts

5.What it should do in the future ?

- sequence and function renaming

- more powerful report generator and viewer

- help on line

6. How you should report the errors?

First of all : operating system, PostgreSQL version,Tcl/Tk version.

A more detailed story of what have you done when error had occurred.

Tcl/Tk stops usually with a error message and there is a button there

"Stack Trace" and if you press it, you will see a detailed information

about the place where it stuck. Please send it to me.

Some information about table structure, no. of fields, records would

be also good.

===========================================================================

You would find always the latest version at http://www.flex.ro/pgaccess

Please feel free to e-mail me with any suggestion or bug description

that will help to improve it.

Constantin Teodorescu <teo@flex.ro>

<METAHTTP-EQUIV="Content-Type"CONTENT="text/html; charset=iso-8859-1">

<METANAME="GENERATOR"CONTENT="Mozilla/4.07 [en] (X11; I; Linux 2.0.36 i586) [Netscape]">

<TITLE>PgAccess - a Tcl/Tk PostgreSQL interface</TITLE>

<BODYBGCOLOR="#FFFFFF">

<metahttp-equiv="Content-Type"content="text/html; charset=iso-8859-1">

<metaname="GENERATOR"content="Mozilla/4.5 [en] (X11; I; Linux 2.0.36 i586) [Netscape]">

<title>PgAccess - a Tcl/Tk PostgreSQL interface</title>

<bodybgcolor="#FFFFFF">

PgAccess - a free database management tool for<AHREF="http://www.postgreSQL.org">PostgreSQL</A></H1>

PgAccess - a free database management tool for<ahref="http://www.postgreSQL.org">PostgreSQL</a></h1>

Download the last version of PgAccess<AHREF="pgaccess-0.93.tar.gz">(press

shift and click this link) (tar.gz file)</A>&nbsp; or&nbsp;&nbsp;<AHREF="pgaccess.zip">this

one (zip file for Windows)</A></LI>

Download the last version of PgAccess<ahref="pgaccess-0.96.tar.gz">(press

shift and click this link) (tar.gz file)</a>&nbsp; or&nbsp;&nbsp;<ahref="pgaccess.zip">this

one (zip file for Windows)</a></li>

<P><BR>Latest stable version of PgAccess is 0.93 , released 10 December

1998 !

<P><FONTSIZE=+2><B><FONTCOLOR="#FF0000">NEW *</FONT></B><B><FONTCOLOR="#FF0000">NEW

*</FONT></B></FONT><B><FONTCOLOR="#FF0000">&nbsp;</FONT><FONTCOLOR="#000000"><FONTSIZE=+1>

==></FONT><FONTSIZE=+2>Microsoft Windows compatible version</FONT></FONT></B>

<P>&nbsp;<B><FONTCOLOR="#FF0000">NEW *</FONT></B> ====><B>PostgreSQL

user management, multiple table views</B>,.<B>Query parameters</B> (see

<p>Latest stable version of PgAccess is 0.96 , released 9 March 1999

!

<p><fontsize=+2>PgAccess 0.93 and higher will not work from the begining

with PostgreSQL 6.3.x !!<br>

Read<ahref="pg93patch.html">here</a> how to apply a simple patch in order

to make it work !</font>

<br>&nbsp;

<p><fontsize=+2><b><fontcolor="#FF0000">NEW *</font></b><b><fontcolor="#FF0000">NEW

*</font></b></font><b><fontcolor="#FF0000">&nbsp;</font><fontcolor="#000000"><fontsize=+1>

==></font><fontsize=+2>Microsoft Windows compatible version</font></font></b>

<p>&nbsp;<b><fontcolor="#FF0000">NEW *</font></b> ====><b>PostgreSQL

user management, multiple table views</b>,.<b>Query parameters</b> (see

section Queries below)

<P>Precompiled libpgtcl and libpq binaries and dll's for i386 are<AHREF="ftp://ftp.flex.ro/pub/pgaccess">here

</A>!!!</CENTER>

<p>Precompiled libpgtcl and libpq binaries and dll's for i386 are<ahref="ftp://ftp.flex.ro/pub/pgaccess">here

</a>!!!</center>

<BR>&nbsp;

<FONTCOLOR="#000080">Installation problems</FONT></H3>

<fontcolor="#000080">Installation problems</font></h3>

Some problems related with locale special characters could be solved by

this<AHREF="specialchars.html">simple patch</A></LI>

this<ahref="specialchars.html">simple patch</a></li>

I think that there were some problems loading libpgtcl library. I invite

you to read a<AHREF="index.html#libpgtcl">special section concerning

libpgtcl</A></LI>

you to read a<ahref="index.html#libpgtcl">special section concerning

libpgtcl</a></li>

For Silicon Graphics Indigo computers, Irix operating system, there is

a<AHREF="irix.html">HOWTO make PgAccess to work</A></LI>

a<ahref="irix.html">HOWTO make PgAccess to work</a></li>

<FONTCOLOR="#191970">What does PgAccess now!</FONT></H3>

Here are some screenshots from PgAccess windows :<AHREF="pic-pga-1.gif">Main

window</A>,<AHREF="pic-pga-2.gif">table builder</A>,<AHREF="pic-pga-4.gif">table(query)

view</A>,<AHREF="pic-pga-3.gif">visual query builder</A>.

<P><B>Tables</B>

<BR>- opening multiple tables for viewing, max. n records (changed by preferences

<fontcolor="#191970">What does PgAccess now!</font></h3>

Here are some screenshots from PgAccess windows :<ahref="pic-pga-1.gif">Main

window</a>,<ahref="pic-pga-2.gif">table builder</a>,<ahref="pic-pga-4.gif">table(query)

view</a>,<ahref="pic-pga-3.gif">visual query builder</a>.

<p><b>Tables</b>

<br>- opening multiple tables for viewing, max. n records (changed by preferences

menu)

<BR>- column resizing, dragging the vertical grid line (better in table

<br>- column resizing, dragging the vertical grid line (better in table

space rather than in the table header)

<BR>- text wrap in cells - layout saved for every table

<BR>- import/export to external files (SDF,CSV)

<BR>- filter capabilities (enter filter like (price>3.14)

<BR>- sort order capabilities (enter manually the sort field(s))

<BR>- editing in place

<BR>- improved table generator assistant

<BR>- improved field editing

<BR><B>Queries</B>

<BR>- define , edit and stores "user defined queries"

<BR>- store queries as views

<BR>- execution of queries with optional user input parameters ( select

<br>- text wrap in cells - layout saved for every table

<br>- import/export to external files (SDF,CSV)

<br>- filter capabilities (enter filter like (price>3.14)

<br>- sort order capabilities (enter manually the sort field(s))

<br>- editing in place

<br>- improved table generator assistant

<br>- improved field editing

<br><b>Queries</b>

<br>- define , edit and stores "user defined queries"

<br>- store queries as views

<br>- execution of queries with optional user input parameters ( select

* from invoices where year=[parameter "Year of selection"] )

<BR>- viewing of select type queries result

<BR>- query deleting and renaming

<BR>- visual query builder with drag &amp; drop capabilities. For any of

<br>- viewing of select type queries result

<br>- query deleting and renaming

<br>- visual query builder with drag &amp; drop capabilities. For any of

you who had installed the Tcl/Tk plugin for Netscape Navigator, you can

see it at work<AHREF="qbtclet.html">clicking here</A>

<BR><B>Sequences</B>

<BR>- defines sequences, delete them and inspect them

<BR><B>Functions</B>

<BR>- define, inspect and delete functions in SQL language

<BR><B>Reports</B>

<BR>- design and display simple reports from tables

<BR>- fields and labels, font changing, style and size

<BR>- saves and loads report description from database

<BR>- show report previews, sample postscript output file

<BR><B>Forms</B>

<BR>- open user defined forms

<BR>- form design module available

<BR>- query widget available, controls bound to query results

<BR>-<AHREF="forms.html">click here</A> for a description of forms and

see it at work<ahref="qbtclet.html">clicking here</a>

<br><b>Sequences</b>

<br>- defines sequences, delete them and inspect them

<br><b>Functions</b>

<br>- define, inspect and delete functions in SQL language

<br><b>Reports</b>

<br>- design and display simple reports from tables

<br>- fields and labels, font changing, style and size

<br>- saves and loads report description from database

<br>- show report previews, sample postscript output file

<br><b>Forms</b>

<br>- open user defined forms

<br>- form design module available

<br>- query widget available, controls bound to query results

<br>-<ahref="forms.html">click here</a> for a description of forms and

how they can be used

<BR><B>Scripts</B>

<BR>- define, modify and call user defined scripts

<BR><B>Users</B>

<BR>- define and modify user parameters

<P>Here is<AHREF="pga-rad.html">a special section concerning forms and

scripts</A> .

<P>This program is protected by the following<AHREF="copyright.html">copyright</A>

<P>If you have any comment, suggestion for improvements, please feel free

to e-mail to :<AHREF="mailto:teo@flex.ro">teo@flex.ro</A>

<P><B><FONTCOLOR="#FF1493"><FONTSIZE=+2>Mailing list for PgAccess</FONT></FONT></B><AHREF="maillist.html">Here

you will find how to subscribe to this mailing list</A>.

More information about libpgtcl - downloads</H1>

<br><b>Scripts</b>

<br>- define, modify and call user defined scripts

<br><b>Users</b>

<br>- define and modify user parameters

<p>Here is<ahref="pga-rad.html">a special section concerning forms and

scripts</a> .

<p>This program is protected by the following<ahref="copyright.html">copyright</a>

<p>If you have any comment, suggestion for improvements, please feel free

to e-mail to :<ahref="mailto:teo@flex.ro">teo@flex.ro</a>

<p><b><fontcolor="#FF1493"><fontsize=+2>Mailing list for PgAccess</font></font></b><ahref="maillist.html">Here

you will find how to subscribe to this mailing list</a>.

More information about libpgtcl - downloads</h1>

&nbsp;&nbsp;&nbsp;&nbsp; Also, you will need the PostgreSQL to Tcl interface

library, lined as a Tcl/Tk 'load'-able module. It is called libpgtcl and

the source is located in the PostgreSQL directory /src/interfaces/libpgtcl.

Specifically, you will need a libpgtcl library that is 'load'-able from

Tcl/Tk.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This is technically different from

an ordinary PostgreSQL loadable object file, because libpgtcl is a collection

of object files. Under Linux, this is called libpgtcl.so.

<P>&nbsp;&nbsp;&nbsp;&nbsp; One of the solutions is to remove from the

source the line containing<B>load libpgtcl.so</B>and to load pgaccess.tcl

<p>&nbsp;&nbsp;&nbsp;&nbsp; One of the solutions is to remove from the

source the line containing<b>load libpgtcl.so</b>and to load pgaccess.tcl

not with wish, but with pgwish (or wishpg) that wish that was linked with

libpgtcl library! I do not recommend this one.

<P>&nbsp;&nbsp;&nbsp;&nbsp; If you have installed RedHat 5.x, you should

<p>&nbsp;&nbsp;&nbsp;&nbsp; If you have installed RedHat 5.x, you should

get the last distribution kit of PostgreSQL and compile it from scratch.

RedHat 5.x is using some new versions of libraries and you have to compile

and install again at least<B>libpq</B>and<B><TT>libpgtcl</TT></B>libraries.

<P>&nbsp;&nbsp;&nbsp; PostgreSQL 6.4 release has a minor bug. I does not

and install again at least<b>libpq</b>and<b><tt>libpgtcl</tt></b>libraries.

<p>&nbsp;&nbsp;&nbsp; PostgreSQL 6.4 release has a minor bug. I does not

includ by default the crypt lib when compiling libpgtcl. So, you will need

to manually add a -lcrypt to SHLIB line in Makefile in src/interfaces/libpgtcl

and then make clean and make again. The new libpgtcl.so library is properly

configured to run pgaccess.

<BR>&nbsp;

<br>&nbsp;