Jffs2ej
Jffs2ej

Reputation: 109

How to save PostgreSQL schema?

I need to send the schema of a PostgreSQL db to the customer.
How can I do that?
I cannot find it in db directory.

Upvotes: 0

Views: 2101

Answers (1)

aleroot
aleroot

Reputation: 72616

It is better to use the pg_dump utility to export the schema and load back on another machine :

pg_dump -U postgres --schema-only db_name > file.txt

And then you can load it back on another machine/instance with the psql utility :

psql -U postgres db_name < file.txt

Upvotes: 8

Related Questions