PgAdmin III 1.9 First Glance

Wednesday, September 24. 2008

We've been playing around with the snapshot builds of PgAdmin III 1.9 and would like to summarize some of the new nice features added. PgAdmin III 1.9 has not been released yet, but has a couple of neat features brewing.

For those interested in experimenting with the snapshot builds and src tarballs, you can download them from http://www.pgadmin.org/snapshots/

Support for TSearch Free Text Search Engine. If you have a 8.3 database and are using 1.9, then you will see the new kid on the block in vibrant colors.
Graphical Query Designer - In 1.9, we see the first blush of a Query Graphical Designer. It all worked nicely except for 2 very annoying things. The way it makes joins - they are implemented as WHERE conditions instead of INNER JOIN, LEFT JOIN, RIGHT JOIN etc which makes its join type implementation <= and >= just incorrect. The other thing is that you can't write an SQL statement and then toggle to the graphical view as you can in hmm MS Access or SQL Server Enterprise Manager, although you can graphically design a query and toggle to the SQL View. As Leo likes to say - "Query graphical designers are over-rated. They breed bad habits. I only care about having a graphical relational designer. Call me when PgAdmin III has that." And off Leo trotted, back to his Open Office Relational Designer.
I still find it quite beautiful and useful in its current incarnation. It at the very least saves a couple of keystrokes. Below are some key niceties it currently provides.
- Ability to see all the schemas, tables at one glance and drag and drop them. Standard and the red-fonting of selected fields I find to be a nice touch.
- Alias table names, fields with one click -
- Basic Criteria support that allows to navigate tree to pick a field - still a bit buggy when you try to delete criteria though
- Easy ability to sort field display order and put in order of fields.
- Toggle to the SQL View to see the generated SQL -
Finally you can see full comments - In 1.8 and before - there was a tiny little window to see function, table comments. But now its a nice big scrollable/expandable window.
Ability to uninherit a table.
Just as in prior 1.8 after making a change to a table, you can toggle to the SQL tab before clicking OK to see what will be executed. This is an immeasurable learning tool. In addition to that, there is an additional Read Only toggle that allows you to uncheck and add additional SQL DDL of your own.

Posted by Leo Hsu and Regina Obe in basics, beginner, ms access, oobase, pgadmin, sql server at 14:26 | Comments (4) | Trackbacks (0)

Defined tags for this entry: pgadmin

Related entries by tags:

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Mmmmhhh, looks like the Graphical query designer is pretty useless for anyone but the most inexperienced user.

#1 pabloj on 2008-09-29 14:07

I don't think it, because it is just a help to start some complex queries with little knowledge of database model, it can helpful for some users, other probably don't like it but is better than nothing.

#1.1 Anonymous on 2011-06-05 19:31

Thank you for sharing.
I rewrite and reprint your article to
http://postgresql-chinese.blogspot.com/2008/10/pgadmin-iii-19.html

#2 ChaoYi, Kuo (Homepage) on 2008-10-02 22:09

Cool - its in Chinese.

Thanks,
Regina

#2.1 Regina on 2008-10-03 10:07

Add Comment

Name
Email
Homepage
In reply to
Comment	Phone* What is two plus three? E-Mail addresses will not be displayed and will only be used for E-Mail notifications. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry