Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: how to insert row with specific oid
Date
Msg-id 1647744.1592576042@sss.pgh.pa.us
Whole thread Raw
In response to how to insert row with specific oid  (ZongtianHou <zongtianhou@icloud.com>)
Responses how to conveniently upgrade with specific catalog change
List pgsql-admin
Tree view 
ZongtianHou <zongtianhou@icloud.com> writes:
> Could I insert a row to table with specific row oid. just like insert into tbl values (xx,xx) oid=xx? Is there some
syntaxto do this? 

Nope, at least not in PG versions that have special oid columns at all.
(Since v12, if you want an OID column, it's just a regular column.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: create batch script to import into postgres tables
Next
From: Adrian Klaver
Date:
Subject: Re: create batch script to import into postgres tables