On Mon, Feb 15, 2016 at 4:27 AM, chandrakant sharma <mike.ck007@gmail.com>
wrote:
> 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 row=
s.
>
> 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
>
>
=E2=80=8BI suspect that target table already existed in target_db and conta=
ined
data.=E2=80=8B All you did was append the records from remote_server to th=
e 1k
that were already present.
David J.