Re: how to insert row with specific oid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ZongtianHou <zongtianhou(at)icloud(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how to insert row with specific oid
Date: 2020-06-19 14:14:02
Message-ID: 1647744.1592576042@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

ZongtianHou <zongtianhou(at)icloud(dot)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 syntax to 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2020-06-19 14:33:27 Re: create batch script to import into postgres tables
Previous Message Adrian Klaver 2020-06-19 13:58:02 Re: create batch script to import into postgres tables