Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump of only range of tables - Mailing list pgsql-general

From Szymon Guz
Subject Re: pg_dump of only range of tables
Date
Msg-id CAFjNrYsdAK_6UTnHTzTvqxGfZe3ODTmD9-NkZv_Dyu6ex23NgQ@mail.gmail.com
Whole thread Raw
In response to pg_dump of only range of tables  (Robert James <srobertjames@gmail.com>)
Responses Re: pg_dump of only range of tables  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view

On 28 October 2013 22:27, Robert James <srobertjames@gmail.com> wrote:
Is there any way to do a pg_dump (or equivalent) of only part of a
table? Say I want to send data to someone for only part of the table
(expressable with a WHERE clause).




Hi,
you can use COPY or \COPY for that: http://www.postgresql.org/docs/9.3/static/sql-copy.html

regards,
Szymon 

pgsql-general by date:

Previous
From: Perry Smith
Date:
Subject: Re: Cursor Example Needed
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump of only range of tables