Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group