Re: how to insert row with specific oid - Mailing list pgsql-admin

From ZongtianHou
Subject Re: how to insert row with specific oid
Date
Msg-id 8138D6E3-C631-48B9-8F18-7F21BBE3520B@icloud.com
Whole thread Raw
In response to Re: how to insert row with specific oid  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: how to insert row with specific oid
Next
From: Pepe TD Vo
Date:
Subject: Re: create batch script to import into postgres tables