Search code examples
mysqlpostgresqlpgadmin

In pgAdmin3 how can I get a UI similar to MySQL Workbench?

I am very new to PostgreSQL and use pgAdmin3 with a PostgreSQL Database.

I am not so good with writing SQL queries. In MySQL Workbench there is a EER UI (diagram representation) that helps us draw new tables easily. Is there a similar graphical representation of EER diagrams in PostgreSQL? If yes, how can I use it to draw a new table?

Solution

  • pgAdmin III has no point-and-click interface to build a query.

    There is, however, a dialog that helps you create tables.