I see what you're saying. I thought it had worked, but when I looked at the dump file there was no data. Thanks.
Cheryl Bender -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Browne Sent: Friday, July 02, 2004 2:15 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Dumping partial database content Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Bender, Cheryl") wrote: > Just wondering--is it possible to dump on a temporary table? The temp table is only visible inside the context of the transaction under which it was created. A pg_dump session will create an independent transaction context, where the table won't be visible, alas. So you can't use pg_dump to dump the data out. You may, however, use COPY to dump it out yourself. select * into temp table foo from bar; copy foo to '/tmp/foo_contents.txt'; -- If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me http://www.ntlug.org/~cbbrowne/postgresql.html Rules of the Evil Overlord #50. "My main computers will have their own special operating system that will be completely incompatible with standard IBM and Macintosh powerbooks." <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
