Re: Possible TODO item: copy to/from pipe

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible TODO item: copy to/from pipe
Date: 2006-05-31 15:26:49
Message-ID: 447DB5B9.9020601@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>
> You can accomplish COPY piping now through psql, but it's a bit awkward:
>
> psql -c "COPY mytable TO stdout" mydb | gzip ...
>
> Thoughts? Is this worth doing, or is the psql -c approach good enough?
>
>

I think it's good enough. And there is also

pg_dump -F c -t bigtable -f bigtable.dump

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-05-31 15:28:33 Re: Possible TODO item: copy to/from pipe
Previous Message Tom Lane 2006-05-31 15:14:27 Re: [PATCH] Magic block for modules