News for hackers. Stuff that matters.
Re:PostgreSQL 8.3 Released by aantix on Monday February 04, 2008 @11:35AM (#109146)
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.

Re:PostgreSQL 8.3 Released by Locke on Monday February 04, 2008 @02:18PM (#109234)
Why not just use psql and '\d my_table'?
Re:PostgreSQL 8.3 Released by lneves on Monday February 04, 2008 @12:13PM (#109161)
> 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?

Re:PostgreSQL 8.3 Released by jawngee on Monday February 04, 2008 @02:31PM (#109245)
PGAdmin for OSX is a steaming pile.

I use a combination of tools:

Aqua Data Studio

PgMaestro via Parallels

Re:PostgreSQL 8.3 Released by pivo on Monday February 04, 2008 @10:52PM (#109510)
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.