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 <ritanjali...@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