Re: pg_dump of only range of tables

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump of only range of tables
Date: 2013-10-28 21:30:58
Message-ID: CAFjNrYsdAK_6UTnHTzTvqxGfZe3ODTmD9-NkZv_Dyu6ex23NgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 28 October 2013 22:27, Robert James <srobertjames(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-10-28 22:01:18 Re: pg_dump of only range of tables
Previous Message Robert James 2013-10-28 21:27:54 pg_dump of only range of tables