agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Jeff Boes <jeff@endpoint.com>
To: pgsql-admin@postgresql.org
Cc: renneyt@yahoo.com <renneyt@yahoo.com>
Subject: Re: PG_DUMP
Date: Fri, 26 May 2006 09:45:24 -0400
Message-ID: <44770674.2010800@endpoint.com> (raw)
In-Reply-To: <4476892A.7090201@yahoo.com>
References: <4476892A.7090201@yahoo.com>
renneyt@yahoo.com wrote:
> Is there a way to do a selective pg_dump of a table using a select
> where clause? As in ... dump all records where now-col_date < 2 or
> col_date='01-may-2006' etc.. ?
You can transfer the subset of data to another table, e.g.,
create table my_dump as select * from table_foo where ...
and then dump that table. Note that you can't do this to a view (pg_dump
will dump the view definition, but not the data).
--
Jeffery Boes <><
jeff@endpoint.com
view thread (42+ messages) latest in thread
Message-ID: <44770674.2010800@endpoint.com>
Permalink: ../44770674.2010800@endpoint.com/
Also on: postgresql.org/message-id/44770674.2010800@endpoint.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jeff@endpoint.com, renneyt@yahoo.com
Subject: Re: PG_DUMP
In-Reply-To: <44770674.2010800@endpoint.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox