How can I export the schema of a database in PostgreSQL?

You should take a look at pg_dump:

pg_dump -s 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

tech