On Fri, May 1, 2009 at 2:25 PM, Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
>>
>> Vadim Trochinsky 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 b
Andrew Dunstan writes:
> Well, you can shoot yourself in the foot using pg_restore's --use-list
> option too, but that doesn't mean it's not useful. And indeed it could
> be used to achieve the OP's ends, except that he would have spent
> useless time and space dumping the data for a table he d
2009/5/1 Tom Lane :
> Andrew Dunstan writes:
>> Tom Lane wrote:
>>> 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).
>
> The use-case seems pretty thin to me, and the p
Tom Lane wrote:
Andrew Dunstan writes:
Tom Lane wrote:
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).
The use-case seems pretty thin to me,
Andrew Dunstan writes:
> Tom Lane wrote:
>> 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).
The use-case seems pretty thin to me, and the potential for shooting
oneself
How do you use -s to exclude data for some tables from otherwise full dump?
Dump schema and data separately?
On Fri, May 1, 2009 at 6:38 PM, Tom Lane wrote:
> Vadim Trochinsky writes:
> > This is a patch that allows choosing not to dump the data for the
> selected
> > tables.
>
> Why wouldn't y
Tom Lane wrote:
Vadim Trochinsky 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 leav
Vadim Trochinsky writes:
> This is a patch that allows choosing not to dump the data for the selected
> tables.
Why wouldn't you just use -s ?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Hello!
This is a patch that allows choosing not to dump the data for the selected
tables.
The intended usage is to make backups smaller and faster, by allowing skipping
unneeded data, while still generating a backup that can be restored and obtain
a fully working application.
I use it to avoi
