Lajos Arpad
Reputation: 77045
How to export schema only for Postgres
I have a very big PostgresSQL database. I would like to dump the schema only. Running
pg_dump -s myschema -f /dump.sql
runs forever, so I suppose it is exporting the data as well. How can I dump the schema only?
Upvotes: 1
Views: 5546
Answers (1)
user330315
Reputation:
-s takes no parameter, you need to use -n or --schema to select the schema you want to dump:
pg_dump -s -n myschema -d mydatabase -f /dump.sql
Upvotes: 6
Related Questions
- PostgreSQL: Export the schema of a database
- Postgres Dumping database with only some schemas
- How do I do a schema only backup and restore in PostgreSQL?
- how to create dump for specific schema in postgres DB
- PostgreSQL export only the schema structure
- Using pg_dump, export entire schema for all tables and data for one table
- Postgres: Dump schema-only but leave data intact for a few tables
- Postgresql - Dump database with x tables - schema only but data from one table
- pg dump output the schema name and the data
- How to get a full list of schemas in pg_dump?