PostgreSQL. Generate create database statement for an existing databse

Question

How to generate the "create table" sql statement for an existing table in postgreSQL Here is explained how to generate such script for one table, but how to do the same for whole database?

are you trying to export the schema? if so stackoverflow.com/questions/14486241/… — FuzzyTree
– FuzzyTree, Commented Nov 19, 2015 at 18:13

serhii · Accepted Answer · 2015-11-19 20:55:00Z

0

I need to extract the script that creates the database and all tables in it.

pgdump -s databasename does this

pgdump -s databasename | awk 'RS="";/TABLE[^;]*;/' allows extract statements of table creating/altering. Unfortunately I don't understand awk syntax.

answered Nov 19, 2015 at 20:55

serhii

1,1772 gold badges15 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL. Generate create database statement for an existing databse

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related