How to dump PostgreSQL database structure (each object in separate file)

Question

I'm using Postgres 8.4 and I want to dump database structure (no data). Is is possible to get each object (table, view, function etc.) in a separate file, NOT EVERYTHING in one file???

You can check my answer in this other post from SO : stackoverflow.com/questions/58869245 — R. Du
– R. Du, Commented Apr 2, 2020 at 10:06

Frank Heikens · Accepted Answer · 2016-10-27 09:44:27Z

1

Use newer version of pg_dump (at least version 9.1) and you can dump to a directory using --format=directory

This will create a directory with one file for each table and blob being dumped

answered Oct 27, 2016 at 9:44

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

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

1 Comment

joop Over a year ago

The separate files are only used for the data, with --schema-only the complete DDL is still compressed into the TOC. (could be possible to extract the parts by applying a script, though)

Collectives™ on Stack Overflow

How to dump PostgreSQL database structure (each object in separate file)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related