Looking for free GUI tool to work with PostgreSQL [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

Currently, I am using standalone GUI tool DbSchema to design my database schema.

I like it because it can

1. Generate SQL code.
2. Have graphing view on my entire database schema.

_{(source: google.com)}

However, I realize the SQL code generate by DbSchema is not being recognized by PostgreSQL.

CREATE TABLE lot (
    lot_id    serial AUTO_INCREMENT NOT NULL,
    operator_name    text,
    machine_name    text,
    timestamp    timestamp,
    CONSTRAINT pk_lot_id PRIMARY KEY(lot_id)) 

CREATE TABLE unit (
    unit_id    serial开发者_如何学Go AUTO_INCREMENT NOT NULL,
    fk_lot_id    serial NOT NULL,
    CONSTRAINT pk_unit_id PRIMARY KEY(unit_id),
    CONSTRAINT fk_lot_id FOREIGN KEY( fk_lot_id ) REFERENCES lot ( lot_id )) 

I get the error :

org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_INCREMENT"

Is there any alternative "just work" free tool that I can work with PostgreSQL, by providing above 2 features?

---

I like the VisualUML/DBA kit. Its not free but it sure is nice. It'll do what you are asking for and it'll generate the DB (with your favorite DBMS) create/drop script for you.

---

Depending on what platform you are working you have some options:

• PgAdmin III
• DreamCoder for PostgreSQL Freeware (Windows)
• Druid III
• OpenOffice.Org(!)
• PgAccess
• Squirrel SQL