postgresql db structure script

Question

How to get my db structure without the data, (schema, tables, ...) as a script by command line.

DrColossos · Accepted Answer · 2010-06-20 12:11:33Z

4

http://www.postgresql.org/docs/current/interactive/app-pgdump.html

pg_dump -s -U username database > backup.sql

Haven't tested it though, so not sure if it works.

edit: had the german link up there ;)

edited Jun 20, 2010 at 12:11

answered Jun 20, 2010 at 11:41

DrColossos

13.1k3 gold badges49 silver badges68 bronze badges

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

3 Comments

Frank Heikens Over a year ago

And the english version: postgresql.org/docs/current/interactive/app-pgdump.html -s only dumps the object definitions (schema), not data.

Figo Over a year ago

Hi, thanks for replying .. I got a permission denied could u tell me why? maybe I wrote some parameters in a wrong way, may you be specific and tell me "username" indicates to a db creator or what ? thanks again

DrColossos Over a year ago

username is the user that has permissions on the database to do the opertaions. This doesn't need to be the DB creator per se, but when this user created it, there will be also the proper permissions.

Collectives™ on Stack Overflow

postgresql db structure script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related