(Sorry for the spam but pgsql-announce refuses to recognize my mail..._
PgBrowse ver 1.5 is a generic Postgresql database browser that works on
Windows, Macintosh and Linux platforms that is written in Tcl/Tk.
A Starpack is available for Linux/x86 and an application bundle
is available for MacOSX.
What is new in 1.5?
o Fixed a bug where columns having uppercase letters in their name
were not processed correctly in the editor.
o Added a "reserved" word LOBJ. If LOBJ appears in the buffer
area of the editor then clicking the update/insert button will
open a file selector box and the user can select a file that
will be inserted into the database as a large object. The oid
of the created object will be placed into the users table
corresponding to the column where LOBJ appeared. The user
will be given a chance to rollback/commit the action.
A couple of features that help differentiate this (free) tool.
1) No postresql software is actually needed on the client.
2) PgBrowser can display graphical images stored in the database
as bytea or large objects (via the Img package).
3) PgBrower supports SQL libraries of your favorite queries. At startup
PgBrowser looks for "~/SQLScripts" and builds a menu of all members of
the directory that end in ".sql". Subdirectories will generate the
appropriate submenu. Selecting a menu item will load the SQL window
with the query.
4) PgBrowser supports a "history" of queries/commands passed to the
backend. Previous commands can be easily recalled from the keyboard.
Gracefully exiting the program will cause the history to be stored
in "~/SQLScripts" as HiStOrY.tcl. This file will be "sourced" at
program startup to recover the command history.
5) If PgBrowser is running on a Mac or Linux system that has
"psql" located in a standard location, it is possible to execute
"psql" commands from within PgBrowser.
6) Individual fields can be extracted and saved to user specified
files. This includes bytea and large object fields.
7) A simple grid based table editor is now available to make
changes in the database. The editor has features that facilitate
the use of BYTEA and Large Object fields.
For more information and download visit:
http://homepage.mac.com/levanj/TclTk
Suggestions for improvements and bug fixes gladly accepted.
Thanks,
Jerry
