Postgres Pro
Downloads
Home   >   mailing lists

dblink (INSERT ..... RETURNING) - Mailing list pgsql-general

From P. Broennimann
Subject dblink (INSERT ..... RETURNING)
Date
Msg-id CACm4aU9jrxohYOYzcoNFbtOJD3Zq_Q7nMMyD6wRkcoSTtBYrEQ@mail.gmail.com
Whole thread Raw
Responses Re: dblink (INSERT ..... RETURNING)  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
Hi there

I have a remote table that I access over dblink.
The table has a primary field set to "autoincrement".

I need now to insert a record in that remote table and get back the new primary field (autoincrement sequence).

Since "bdlink_exec" can not give back rows I tried to use "dblink", but I can not figure out how to format that INSERT... RETURNING query?

Thanks,
P.

pgsql-general by date:

Previous
From: Mark van Leeuwen
Date:
Subject: Re: Exclusive row locks not release
Next
From: Florian Weimer
Date:
Subject: Re: On duplicate ignore