Re: Possible TODO item: copy to/from pipe - Mailing list 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