Cross DB insert with returning id

Поиск
Список
Период
Сортировка
От Ritanjali M
Тема Cross DB insert with returning id
Дата
Msg-id CAOuzsCR+zjH5_qwnUUugMsTTyxUasxOGEO4HhtEKL7RHGjzzWg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cross DB insert with returning id  (Peter Devoy <peter@3xe.co.uk>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Why is the comparison between timestamp and date so much slower then between two dates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: Why is the comparison between timestamp and date so much slower then between two dates