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.