On Mon, Aug 15, 2011 at 6:10 AM, Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz> wrote:
> Hi
> I want to pg_dump only a select amount of rows from a table and restore them
> to a table on another server.
> Is there away to do this? I thought of using a view but how would I upload
> that into a specific table. Copy? or is there something I can do with
> pg_restore.
You want to combine copy and select like so:
copy (select * from table where ...) to stdout;