PostgreSQL database reverse engineering from shell level

Question

I happened to do some moderating stuff with large database but I am not so experienced in it so i guess the smart thing is to create similar database on my localhost to not mess up with original one.

And here is my question, is it possible to generete SQL script which will create exact table as i want?
I mean on MySQL GUI tool there is option like this, reverse engineering which generate SQL script which will create exact database as I used function on, is it possible in PostgreSQL in shell level?

Richard Huxton · Accepted Answer · 2013-02-01 09:31:20Z

3

pg_dump --schema-only db1 > db-schema.sql

edited Feb 1, 2013 at 9:31

user330315

answered Feb 1, 2013 at 8:48

Richard Huxton

23.6k5 gold badges43 silver badges53 bronze badges

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

2 Comments

Grzzzzzzzzzzzzz Over a year ago

does it not takes records saved with it? Is it possible to use it somehow only on tables with out records? edit: ahh ok --schema-only i get it. Thank you Richard.

Richard Huxton Over a year ago

That is what --schema-only does. Read the manual for full details postgresql.org/docs/current/static/app-pgdump.html

Collectives™ on Stack Overflow

PostgreSQL database reverse engineering from shell level

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related