November 20, 2005
This utility lets you view an SQL table with the SQL command SELECT. Other commands that expect data back are not (yet?) supported.
It also lets you make SQL commands that do not expect an answer back, like INSERT, UPDATE or DELETE. Only if an error occurs a short explanation is returned by PostgreSQL and displayed in the bottom window, below the query window.
|
Connect |
If you are not yet connected to PostgreSQL before you do anything you must get a connection. Hit the Connect button and the Connect to PostgreSQL dialog will let you connect to the desired database. |
|
Make Query |
After having connected to PostgreSQL the Tables combo box will be populated with all the available tables. Make the appropriate query and then hit the Make Query button. |
At this moment Pragma 6 connects to PostgreSQL with the ODBC interface. For some still obscure reason the maximum number or rows a SELECT query fetches is 25. This will of course change when Pragma will use native PostgreSQL functions to query the database.
Another temporary problem is that when you make multiple queries without leaving the dialog box the List Control element adds the new columns to the old ones. This is because there is not a simple command to clear the List Control completely (or I have not yet found it).
Please let me know your suggestions, bugs or whatever you think can be done to this utility and or explanation to make it more useful.
Please write your comments to the Pragma listserver at the following address: pragma@houseware.nl
If you arte not yet on the Pragma listserver list you can subscribe by sending an e-mail to the listserver with "Subscribe" in the subject.