Thank you for the detailed answer! > On Jun 19, 2020, at 3:13 PM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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 >