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:/
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