On Mon, Aug 15, 2011 at 6:10 AM, Rebecca Clarke <rebecca@xxxxxxxxxxxxx> 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; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
