40

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

2 Answers 2

66

pg_dump --schema-only

5
  • easier than I realized it would be :)
    – warren
    Aug 31, 2009 at 4:22
  • 3
    Frankly, I haven't much clue about postgres administration, but I've been watching videos from pgcon 09 and someone mentioned pg_dump.
    – jldugger
    Aug 31, 2009 at 4:27
  • either way - it's what I needed :)
    – warren
    Sep 7, 2009 at 13:41
  • 7
    @warren: it's even easier: pg_dump -s.
    – hans0l0
    Nov 20, 2013 at 14:58
  • This command dumps everything and not only table structure: --schema-only Dump only the object definitions (schema), not data docs
    – arod
    Aug 11, 2022 at 18:30
19

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

9
  • 6
    Not sure why the downvotes as this command works perfectly. So +1 from me.
    – Dave
    Mar 4, 2017 at 19:17
  • 5
    That was the rigth answer to me, because i couldn't create file with functions, views and etc. Jun 18, 2018 at 12:27
  • 1
    @Dave because adding an additional option not at all linked to the initial question 6 years later is not that useful.
    – Arne
    Nov 21, 2018 at 13:28
  • 1
    @Arne. Disagree. The question title, which specifies dumping "only the table structure", gives this page a high search rank. And plenty of people, like Natan who remarked prior to you, want to avoid moving functions and/or views from old extensions in the event that they are starting with a fresh db with updated extensions. So it absolutely is "useful", as opposed to "not useful", which are the voting criteria. Absolutely getting my +1.
    – elrobis
    Aug 9, 2019 at 19:23
  • 1
    @Dave. I think that this answer is right. I opened because the title. I'm searching table-only struct dump. This is better than the other or the title is not acurated. Oct 9, 2019 at 14:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .