Cross DB insert with returning id

You may wish to consider using the Postgres Foreign Data Wrapper to
access your other database:

http://www.postgresql.org/docs/9.3/static/postgres-fdw.html

And then use RETURNING to get your ID, e.g.:

INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets')
RETURNING did;

http://www.postgresql.org/docs/9.3/static/sql-insert.html

Kind regards

Peter

On 14 April 2016 at 14:50, Ritanjali M <ritanjalim60@gmail.com> wrote:

Hi Team,

I am new to postgresql ,i need to create one function where i have to insert
data into cross database table from that table identity value i need to
insert some other table other database within one function .i am able to
insert the data into cross DB table using dblink_exec but i unable to get
the identity value ,so how could i will get identity value from cross
DB.please help me out with the example.

--
Thanks & Regards
Ritanjali Majhee

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general