postgresqldatabase-schemaschema-designdatabase-tools

PostgreSQL schema design

What is your preferred way of designing PostgreSQL schemata? Would you recommend the use of specific graphical design tools or just design the schema on paper and create everything by hand?

Solution

  • You can also try

    for creating ER diagrams.

    For managing the DDL scripts, I have good experience with Liquibase and Power Architect can also create the Liquibase XML directly from the ER diagram.