40

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

Improve this question

2 Answers 2

Reset to default
66

pg_dump --schema-only

Improve this answer
5
  • easier than I realized it would be :) Commented 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. Commented Aug 31, 2009 at 4:27
  • either way - it's what I needed :) Commented Sep 7, 2009 at 13:41
  • 7
    @warren: it's even easier: pg_dump -s. Commented 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 Commented Aug 11, 2022 at 18:30
21

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

Improve this answer
9
  • 6
    Not sure why the downvotes as this command works perfectly. So +1 from me. Commented 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. Commented 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. Commented 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. Commented 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. Commented Oct 9, 2019 at 14:20

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.