PgBrowse ver 1.4 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.4?
o Fixed a bug where fields greater than 200 characters could not be
edited.
o Added the ability to insert or update bytea fields in the editor.
If the
edit buffer contains the unquoted word BYTEA for the value of a
column
then when an UPDATE or INSERT is done the program will allow the user
to select a file to be used as the contents of the field.
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.
For more information and download visit:
http://homepage.mac.com/levanj/TclTk
Suggestions for improvements and bug fixes gladly accepted.
Thanks,
Jerry
