Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Feature: give pg_dump a WHERE clause expression
Date
Msg-id 20097.1212331398@sss.pgh.pa.us
Whole thread Raw
In response to Feature: give pg_dump a WHERE clause expression  (Davy Durham <pubaddr5@davyandbeth.com>)
Responses Re: Feature: give pg_dump a WHERE clause expression  (Davy Durham <pubaddr5@davyandbeth.com>)
List pgsql-patches
Tree view 
Davy Durham <pubaddr5@davyandbeth.com> writes:
>   I have added a new parameter, -w/--where=EXPR
>   This lets you specify an expression that will be used in a WHERE
> clause when the data is dumped.

This seems pretty poorly thought out.  It can hardly work in a dump
of more than one table, which means that there's not any real reason
to use pg_dump at all.  Just do a COPY (SELECT ...) TO somefile.

            regards, tom lane

pgsql-patches by date:

Previous
From: Davy Durham
Date:
Subject: Feature: give pg_dump a WHERE clause expression
Next
From: Alvaro Herrera
Date:
Subject: Re: partial header cleanup