Mathias Hillmann
Reputation: 1837
Postgres Dumping database with only some schemas
I have a database called supre with the following schemas cdu, beirario, lider, koch, public, however I would like to dump the database with only the schemas cdu, beirario, public.
Following postgres' documentation I found the -s flag, however that states that it only dumps the schema and a pg_restore wouldn't work with only that.
How can I achieve this?
Upvotes: 0
Views: 57
Answers (1)
Laurenz Albe
Reputation: 247665
Use the -n option:
pg_dump -n cdu -n beirario -n lider ... dbname
Upvotes: 1
Related Questions
- How do I do a schema only backup and restore in PostgreSQL?
- How to export schema only for Postgres
- 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
- Getting a clean backup of my schema from PostgreSQL
- How can I `pg_dump` the entire schema and the data from **some** tables?
- Taking dump of the database without getting specific table records :Postgres