Hello Team,
I tried using the following command line argument to restore a table on the
fly using pg_dump. The source and target dbs are GP. The process completed
successfully however, the number of rows in the target were higher than as
compared to source. The difference was greater the 1K rows.
Here is the command line used:
pg_dump -a -x -U remote_user -h remote_server -t table_to_copy source_db |
psql target_db
Version of pg_dump being used:
pg_dump (PostgreSQL) 8.4.20
--
Thanks and Regards
Chandrakant Sharma