PostgreSQL: Export the schema of a database

You should take a look at pg_dump:

pg_dump --schema-only databasename

Will dump only the schema to stdout as .sql.

For windows, you’ll probably want to call pg_dump.exe. I don’t have access to a Windows machine but I’m pretty sure from memory that’s the command. See if the help works for you too.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)