pg_dump -t: give WHERE condition

#1

Hi,

I want to dump some rows of a table. I couldn't find a way to
give pg_dump a where condition.

How can you dump (for restore) with a where-condition?

Thomas

#2

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:

Quote:

I want to dump some rows of a table. I couldn't find a way to
give pg_dump a where condition.

How can you dump (for restore) with a where-condition?

You cannot specify a where clause for pg_dump.

You can use COPY (or \copy in psql) to dump the results of an
arbitrary SQL query to a file.

Use COPY (or \copy) to restore the result to another table.

Yours,
Laurenz Albe

#3

Thank you Toby and Laurenz for your solutions.

Toby A Inkster schrieb:

Quote:

Laurenz Albe wrote:

You can use COPY (or \copy in psql) to dump the results of an arbitrary
SQL query to a file.

Personally, I'd...

$ psql mydb
> CREATE TABLE temp1 (LIKE mytable);
> INSERT INTO temp1 SELECT * FROM mytable WHERE myconditions;
> \q
$ pg_dump --data-only --column-inserts -t temp1 mtdb >out.sql
$ psql mydb
> DROP TABLE temp1;
> \q

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

pg_dump -t: give WHERE condition

comp.databases.postgresql comp.databases.postgresql

pg_dump -t: give WHERE condition - 12-03-2007 , 08:36 AM

Re: pg_dump -t: give WHERE condition - 12-03-2007 , 09:00 AM

Re: pg_dump -t: give WHERE condition - 12-04-2007 , 10:06 AM