Re: how to insert row with specific oid

Поиск
Список
Период
Сортировка
От ZongtianHou
Тема Re: how to insert row with specific oid
Дата
Msg-id 8138D6E3-C631-48B9-8F18-7F21BBE3520B@icloud.com
обсуждение исходный текст
Ответ на Re: how to insert row with specific oid  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Thank you for the detailed answer!

> On Jun 19, 2020, at 3:13 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> 
> On Fri, 2020-06-19 at 15:02 +0800, ZongtianHou wrote:
>> Could I insert a row to table with specific row oid. just like insert
>> into tbl values (xx,xx) oid=xx? Is there some syntax to do this?
> 
> No, you cannot determine the OID that will be inserted.
> 
> Using tables WITH OIDS is deprecated, and the feature is gone in v12.
> 
> If you want to insert specific values, you shouldn't be using a
> system-generated OID but a regular column of type "bigint" or so.
> 
> Yours,
> Laurenz Albe
> -- 
> Cybertec | https://www.cybertec-postgresql.com
> 




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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: how to insert row with specific oid
Следующее
От: Pepe TD Vo
Дата:
Сообщение: Re: create batch script to import into postgres tables