A better interface than pgadmin3?

[keak]

Hi there,
I've been using mysql, but recently I am trying to learn postgres as well. I installed pgadmin3, but I was wondering if there is a better interface program ....
It sometimes crashes when I view large table, and I did spot some other errors.

I was wondering if there were any similar programs to MysqlCC,SQLYog, but for postgres?

 

[ceco]

I don't know what mysqlcc and sqlYog are
but on the news archive there are quite a lot of announcments for new versions of interface programs (

http://www.postgresql.org/about/newsarchive)

I have only seen the EMS products, but use only the command line psql, and from time to time phpPgAdmin, and the one you don't like pgadmin3
take a look there you may like some of them

 

[skiflyer]

phpPgAdmin rocks.. unfortunately it doesn't display the SQL used for every command like phpMyAdmin (which I found to be not only a great admin tool but a great learning tool)

For normal clients you can't beat EMS with PostgreSQL in my experience... I've never shelled out for the pay version which has great visual ERD tools supposedly, but the free version is great in and of itself.

 

[gwinn7]

I just installed the trial for 'PG Lightning'. It looks fairly impressive. It is also mentioned on the link Ceco left for you above.

Gary
gwinn7

 

[SteveBrett]

why don't you try using psql for a while. I did this a few years ago when my then boss wouldn't allow me to install XWindows on a server. It did wonders for my understanding of DDL and DML.

Give it a go for a few weeks, you might suprise yourself.