Re: dumping only table definitions

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Kevin Brannen <KBrannen(at)efji(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: dumping only table definitions
Date: 2018-06-29 22:39:49
Message-ID: 20180629223949.tdifrvvqejuqyl2i@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-Jun-29, Kevin Brannen wrote:

> I'm trying to figure out how to dump only the table definitions, well those and things they need directly, like sequences & types. What I do NOT want are all the millions (not literally but it feels like it :)) of functions we have. Triggers would be all right if I must, as we only have a few of those.

Try "pg_dump -Fc" followed by pg_restore -l. You can edit the list
emitted there, then use it with pg_restore -L.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-06-29 22:43:28 Re: dumping only table definitions
Previous Message Kevin Brannen 2018-06-29 22:30:09 dumping only table definitions