Reputation: 109
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
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