Dump a database excluding one table DATA? - Mailing list pgsql-general

From Dmitry Koterov
Subject Dump a database excluding one table DATA?
Date
Msg-id CA+CZih4cWaYN8=7-Mifp1jidrWMT+t3KHFT-X6dft7Kb1nf5Tg@mail.gmail.com
Whole thread Raw
Responses Re: Dump a database excluding one table DATA?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Dump a database excluding one table DATA?  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-general
Hello.

Is there any way (or hack) to dump the whole database, but to exclude the DATA from a table within this dump? (DDL of the table should not be excluded: after restoring the data the excluded table should look "empty".)

I see -T switch of pg_dump, but seems -T excludes the data AND the DDL of a table (and possibly all objects which depend on this table?), so after restoration the database structure becomes broken sometimes.

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Using Postgresql as application server
Next
From: John Cheng
Date:
Subject: Re: call initdb as regular user