diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1998-02-19 16:43:54 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1998-02-19 16:43:54 +0000 |
| commit | ef12012e5b21c3c417195f104e1eea9027e77a4b (patch) | |
| tree | 44e2921f6b43c16b3266d7c13b43ac7975a95976 /src/bin/pgaccess/README | |
| parent | 9540d9786e3b82ba1882d1ed4719cbd03adef7cd (diff) | |
| download | postgresql-ef12012e5b21c3c417195f104e1eea9027e77a4b.tar.gz | |
Updated from 0.61->0.76
Diffstat (limited to 'src/bin/pgaccess/README')
| -rw-r--r-- | src/bin/pgaccess/README | 150 |
1 files changed, 0 insertions, 150 deletions
diff --git a/src/bin/pgaccess/README b/src/bin/pgaccess/README deleted file mode 100644 index db7ebeec09..0000000000 --- a/src/bin/pgaccess/README +++ /dev/null @@ -1,150 +0,0 @@ ---------------------------------------------------------------------------- - - - -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.61 , 14 October 1997 -================================ -I dedicate this program to my little 4 year daughter Ana-Maria and 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. - -I use Tcl/Tk because it's a powerfull language, and it took me only -four days of hard work to get it as you see it now. - - - -2.How to INSTALL ? - -You will need Tcl/Tk package, I am using now Tcl 7.6 and Tk 4.2. There -are some problems running under Tcl/Tk 8.0 but I will soon fix them. - -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 director (/usr/lib) and -go for it. - - -3.How to run it? - -You run it with the command: - - wish -f pgaccess.tcl - -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. -- Perform vacuum command. -- Saves preferences in ~/pgaccessrc file - -Tables -- opening tables for vieweing, max 200 records -- 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 lizzard :-) (not wizzard) -- 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 -- vieweing of select type queries result -- running action queries (insert, update, delete) -- query lizzard (visual query builder) with drag & drop support - -Sequences -- define -- inspect -- delete - -Views -- defining them saving queries as views -- view them , with filtering and sorting capabilities -- delete them - -Functions -- define , inspect , delete - - - -5.What it should do in the future ? - -- table design (add new fields, renaming, etc) -- sequence and function renaming -- script execution (simple SQL commands) -- a simple 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 occured. -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 stucks. Please send it to me. -Some information about table structure, no. of fields, records would -be also good. - -=========================================================================== -You would find always the last 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 this. - -Constantin Teodorescu <teo@flex.ro> - |
