Greenplum - Merge tables in two different database instances

(1) Solution 1:


pg_dump -d launchpad -t src_flr_sum2 | psql lsi
psql -d lsi
insert into src_flr_sum select * from src_flr_sum2;

(2) Solution 2:

http://blog.2ndquadrant.com/using_dblink_in_greenplum/