Presently, I'm using stand alone GUI tool DbSchema to create my database schema.
I love it since it can
- Generate SQL code.
- Have graphing take on my entire database schema.
However, I recognize the SQL code generate by DbSchema isn't being identified 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 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 recieve the mistake :
org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_INCREMENT"
Can there be what other "just work" free tool will be able to use PostgreSQL, by supplying above 2 features?
I love the VisualUML/DBA package. It is not free but it definately is nice. It'll do what you're requesting and will also create the DB (together with your favorite DBMS) create/drop script for you personally.