Re: Feature: give pg_dump a WHERE clause expression - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: Feature: give pg_dump a WHERE clause expression
Date
Msg-id 4843092F.1030004@dunslane.net
Whole thread Raw
In response to Re: Feature: give pg_dump a WHERE clause expression  (daveg <daveg@sonic.net>)
Responses Re: Feature: give pg_dump a WHERE clause expression  (daveg <daveg@sonic.net>)
List pgsql-patches

daveg wrote:



>> ISTM this would be better off waiting until we turn large parts of
>> pg_dump into a library, as has been often discussed, at which point it
>> should be relatively simple to write a custom client to do what the OP
>> wants. I agree that it does not at all belong in pg_dump.
>>
>
> I can't imagine many of my clients ever writing another C program or even
> being willing to pay me to do so. While modularizing pg_dump is a fine idea,
> I don't think it addresses the same set of use cases and users as this
> proposal.
>
>
>

It's not clear to me that your use case is very compelling. Does your
foreign database not support import via CSV or XML? Postgres can now
produce both of these for any arbitrary query.

cheers

andrew

pgsql-patches by date:

Previous
From: Davy Durham
Date:
Subject: Re: Feature: give pg_dump a WHERE clause expression
Next
From: daveg
Date:
Subject: Re: Feature: give pg_dump a WHERE clause expression