default_with_oids

• 11
• 10
• 9.6
• 9.5
• 9.4
• 9.3
• 9.2
• 9.1
• 9.0
• 8.4
• 8.3
• 8.2

PostgreSQL 11 及更早版本

postgres=# SET default_with_oids TO on;
SET

postgres=# CREATE TABLE table_with_oids (id int, val text);
CREATE TABLE

postgres=# INSERT INTO table_with_oids VALUES (1, 'foo');
INSERT 16461 1

postgres=# SELECT oid, id, val FROM table_with_oids ;
  oid  | id | val 
-------+----+-----
 16461 |  1 | foo
(1 row)

postgres=# SET default_with_oids TO off;
SET

postgres=# CREATE TABLE table_without_oids (id int, val text);
CREATE TABLE

postgres=# INSERT INTO table_without_oids VALUES (1, 'foo');
INSERT 0 1

postgres=# SELECT oid, id, val FROM table_without_oids ;
ERROR:  column "oid" does not exist
LINE 1: SELECT oid, id, val FROM table_without_oids ;
               ^

• PostgreSQL 11 文档： default_with_oids