Re: Table data exclusion patch for pg_dump - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Table data exclusion patch for pg_dump
Date
Msg-id 3073cc9b0905011436l69db0e47la46603d59a7b06bc@mail.gmail.com
Whole thread Raw
In response to Re: Table data exclusion patch for pg_dump  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Fri, May 1, 2009 at 2:25 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> Tom Lane wrote:
>>
>> Vadim Trochinsky <me@vadim.ws> writes:
>>
>>> This is a patch that allows choosing not to dump the data for the
>>> selected tables.
>>>
>> Why wouldn't you just use -s ?
>>
>
> You might want the whole schema and data for most but not all of the tables
> (e.g. you might leave out a large session table for a web app).
>

Actually you can use pg_dump -T to exclude some tables and then
pg_dump -s -t to dump the schema of those tables


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Gist consistent and compression
Next
From: Tom Lane
Date:
Subject: Re: windows shared memory error