(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
