Re: Dumping partial database content
От | Bender, Cheryl |
---|---|
Тема | Re: Dumping partial database content |
Дата | |
Msg-id | D5DB5D0D27171247AFEC9648EE98752F032125CB@KCEX2KV1.mri-kc.int обсуждение исходный текст |
Ответ на | Dumping partial database content (h_harush@hotmail.com) |
Список | pgsql-admin |
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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Christopher Browne Sent: Friday, July 02, 2004 2:15 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Dumping partial database content Martha Stewart called it a Good Thing when cbender@mriresearch.org ("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
В списке pgsql-admin по дате отправления: