Postgres Help

Dear Team,

I want to insert data from client server to central server (remote) using
pgadmin III in postgresql.

e.g.

SELECT dblink_exec('host=remote central server IP port=5432 dbname=test
user=test password=test',

'insert into t_table1' from dblink('host=client Server port=5432
dbname=test1 user=test1 password=test1 ','SELECT * FROM t_table2

when we execute above query it is taking central server table only and not
considering table2 (client server)

Kindly help.

I want to execute above query for multiple sites.

--
Regards,
Sandip Parlikar

--

*Download SteamHUB - the smart app for steam users. This app is currently
available for Android phones – click here to download
now.http://www.forbesmarshall.com/mobileApp/steamHUB/
<http://www.forbesmarshall.com/mobileApp/steamHUB/>*

DISCLAIMER:This email (and any attachment) is confidential, may be legally
privileged and is intended solely for the use of the individual or entity
to whom it is addressed. If you are not the intended recipient please do
not disclose, disseminate, distribute, copy or take any action in reliance
on it. If you received this message in error please tell us by reply (or
telephone the sender) and delete all copies on your system. Although we
have taken reasonable precautions to ensure no viruses are present in this
email, we cannot accept responsibility for any loss or damage arising from
the use of this email or attachments and would advise that you carry out
your own virus scan before opening any attachment.

****************************************************************