Here is a freebie for MacOSX users... BiggerSQL is a postgresql browser and more. Only tested on MacOS X 10.3.2 and Postgresql 7.4.1. Cocoa source is part of the package. I understand that BiggerSQL might need to be rebuilt if your backend is not compatible with the 7.4 release. The program links with libpg for most of the dirty work.
Feedback and suggestions welcomed...
BiggerSQL Version History.
Available at: http://homepage.mac.com/levanj/Cocoa
Feb 29, 2004 Version 1.0 released. Features include an info drawer which shows info about the tables that the user owns, support for execution of selections or individual lines in the editor window and support for reasonably formated PL/pgSQL definitions. On line help for SQL commands and running the program
Mar 4, 2004 Version 1.1 released. This version added drag and drop of text files to the editor window.
Mar 7, 2004 Version 1.2 released. Added all viewable tables and views to the info outline view. Double clicking on a table/view in the info drawer will clear the editor window and execute a "select * from <selected table>" command. This facilitates browsing the database.
Two major memory leaks were discovered and plugged. This revealed a major problem with how the info panel was being refreshed. Hopefully this bug has been squashed.
Mar 8, 2004 Version 1.2.1 released. I decided that showing all of the system tables all the time was a bit much, so I added a menu item to the 'File' menu to enable/disable the display of the tables in the pg_catalog and information_schema schemas.
Mar 9, 2004 Version 1.2.2 released. This version adds a script menu. During startup BiggerSQL looks for the directory ~/Library/BiggerSQL. If it is not present the directory is created. If the directory exists it is scanned and any file ending with ".sql" will generate a menu item having the file's name in the Scripts menu. The user is encouraged to save their favorite sql scripts in this folder. Selecting such an item will cause the editor window to be replaced with the contents of the file. The first item in the Scripts menu is "Open Script Folder". Choosing this item will cause the scripts folder located in the users Library directory to be opened by the Finder and made the front most window. The user could then drag files from this window onto the editor window.
--Jerry
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
