How can I do a dump of only the table structure in PostgreSQL?

Question

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?

score 66 · Accepted Answer · answered Aug 31 '09 at 04:19

66

pg_dump --schema-only

answered Aug 31 '09 at 04:19

jldugger

arod · Answer 2 · 2017-03-04T22:46:02.350

21

If you only want the CREATE TABLE statements, then you can do pg_dump -s databasename | awk 'RS="";/CREATE TABLE[^;]*;/'

edited Mar 04 '17 at 22:46

answered May 28 '15 at 18:22

arod

2 Answers2