PgAdmin III 1.9 First Glance   Checkout our PostGIS in Action book. First chapter is a free download

Postgres OnLine Journal

Blog View    Periodical View   Book Store   About the Authors   Consulting   PostgreSQL   PostGIS


PostgreSQL Books   Database Programming Books Linux Books

Wednesday, September 24. 2008


PgAdmin III 1.9 First Glance

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/

  1. 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.
    PgAdmin 1.9 FTS tree
  2. 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 - PgAdmin GQD SQL View
  3. 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.
  4. Ability to uninherit a table.
  5. 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. SQL comment view
Posted by Leo Hsu and Regina Obe in basics, beginner, ms access, oobase, pgadmin, sql server at 14:26 | Comments (3) | Trackbacks (0)
Defined tags for this entry:
Related entries by tags:
Bookmark PgAdmin III 1.9 First Glance at del.icio.us Digg PgAdmin III 1.9 First Glance Bloglines PgAdmin III 1.9 First Glance Technorati PgAdmin III 1.9 First Glance Fark this: PgAdmin III 1.9 First Glance Bookmark PgAdmin III 1.9 First Glance at YahooMyWeb Bookmark PgAdmin III 1.9 First Glance at Furl.net Bookmark PgAdmin III 1.9 First Glance at reddit.com Bookmark PgAdmin III 1.9 First Glance at blinklist.com Bookmark PgAdmin III 1.9 First Glance at Spurl.net Bookmark PgAdmin III 1.9 First Glance at Simpy.com Bookmark PgAdmin III 1.9 First Glance at blogmarks

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Buy PostGIS in Action from Amazon or Manning  Freee Open source GIS Conference in Barcelona 2010

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 (Reply)
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 (Reply)
Cool - its in Chinese.

Thanks,
Regina
#2.1 Regina on 2008-10-03 10:07 (Reply)

Add Comment

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.
CAPTCHA
 
 

Quicksearch

Calendar

Back September '10
Mon Tue Wed Thu Fri Sat Sun
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

Categories



All categories

Archives

Syndicate This Blog

Powered by

Serendipity PHP Weblog

Blog Administration

Open login screen

Entry's Links

Show tagged entries