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