Pg_dump Query

From: Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Pg_dump Query
Date: 2011-08-15 12:10:16
Message-ID: CANY3h+QshA5NszEVTbOjMj34FH2PDcDmGzmHqEMKUbN_ftbBsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Rebecca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-08-15 13:47:10 Re: Pg_dump Query
Previous Message Thomas Markus 2011-08-15 11:50:27 Re: How to tame a gigantic (100+ lines) query in a web app?