| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vadim Trochinsky <me(at)vadim(dot)ws>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Table data exclusion patch for pg_dump |
| Date: | 2009-05-01 21:36:32 |
| Message-ID: | 3073cc9b0905011436l69db0e47la46603d59a7b06bc@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, May 1, 2009 at 2:25 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>
> Tom Lane wrote:
>>
>> Vadim Trochinsky <me(at)vadim(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-05-01 22:24:16 | Re: windows shared memory error |
| Previous Message | Joshua D. Drake | 2009-05-01 21:18:25 | Re: Throw some low-level C scutwork at me |