On: PostgreSQL 8.3 Released

[aantix]

While I have enjoyed Postgres's reliability, the clients (for OSX) have left me feeling empty.

A majority of the time I just want to see the tables. When using pgAdmin3, I am forced to expand Servers->Local Server->Databases-><the desired database>->Schema->Public->Tables

And then when I finally get to the table I want, if I double click it, it brings up the properties for the table? Huh?

So I figure out I must click the table icon on the toolbar to bring up the table. Instead of bringing up the data within the same pane, it pops up a second window? Grrr....

While the tool gets the job done, I'm starting to miss MySQL just for the sake of having CocoaMySQL at my side.

[Locke → aantix]

Why not just use psql and '\d my_table'?

[lneves → aantix]

> When using pgAdmin3, I am forced to expand Servers->Local Server->Databases-><the desired database>->Schema->Public->Tables

Yes, that is annoying, but at least the 1.8.1 version of pgAdmin opens in the last db/schema used... that is the behavior I get.

> So I figure out I must click the table icon on the toolbar to bring up the table. Instead of bringing up the data within the same pane, it pops up a second window? Grrr....

File -> Options -> Preferences. Unmark "Show object properties on doubleclick in treeview?" Does that help?

[jawngee → aantix]

PGAdmin for OSX is a steaming pile.

I use a combination of tools:

Aqua Data Studio

PgMaestro via Parallels

[pivo → aantix]

I just started using Navicat Lite for PostgreSQL on OSX. Not open source, but free and seems pretty nice so far. Might be worth a look.