Re: Postgres Help

On Mon, 18 Apr 2016 08:26 PARLIKAR, Sandip, <sparlikar(at)forbesmarshall(dot)com>
wrote:

> 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)
>

What is the version of Postgres that you are using?
On central server and the federated server?

A rough diagram of setup would be helpful.

> 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.
>
> ****************************************************************
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com