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
