PostgreSQL export only the schema structure

Question

I have a Database which has multiple schema, I need to export one of those schema structure to an sql file without the data. Is this possible, if so What command should I use?

When I use this command, I get the data as well, but I have a lot of data which makes the server run out of space for this.

--host xx --port xx --username "xx" --password  --format plain --verbose --file "sample.sql" --schema "sample" "main"

I need the structure to restore it in another location. Where I do not need the data but only the structure

I'm quite new to this area, thanks for the help

Possible duplicate of How can I export the schema of a database in PostgreSQL? — Huseyin Yagli
– Huseyin Yagli, Commented Mar 22, 2018 at 21:29

Sandeep Sukhija · Accepted Answer · 2018-05-08 06:05:04Z

12

Use can use pg_dump with the option -s. Follow the link pg_dump help

To extract the schema for a single database, use

pg_dump -s <schema_name>

edited May 8, 2018 at 6:05

answered Mar 15, 2016 at 6:08

Sandeep Sukhija

1,17617 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL export only the schema structure

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related