Re: db partial dumping with pg_dump - Mailing list pgsql-hackers

On Wed, 2002-08-14 at 00:03, Bruce Momjian wrote:
> 
> Actually, loading all this stuff into COPY is not the way to go, I
> think.  
> 
> Informix had:
> 
>     UNLOAD TO 'filename'
>     SELECT ...
> 
> I have to admit, this is a superior way to do thing compared to what we
> have.  Is is possible for us to get:
> 
>     COPY TO 'filename'
>     SELECT ...
> 
> It allows any arbitrary table, group by, even order by combination.


It would be more in line with the rest of the system to just allow
subselect as 'table'

COPY (select in,name from mystuff wher id > 10) over10stuff TO stdout;

-----------------
Hannu