t1=# show default_with_oids; default_with_oids ------------------- off (1 row) t1=# create table defoffwithoids(a int) with(oids=on); CREATE TABLE t1=# create table defoffwithoutoids(a int) with(oids=off); CREATE TABLE t1=# \d+ defoffwithoutoids Table "public.defoffwithoutoids" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- a | integer | | plain | | t1=# \d+ defoffwithoids Table "public.defoffwithoids" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- a | integer | | plain | | Has OIDs: yes . . . . postgres=# show default_with_oids; default_with_oids ------------------- on (1 row) postgres=# create table defonwithoutoids(a int) with(oids=off); CREATE TABLE postgres=# create table defonwithoids(a int) with(oids=on); CREATE TABLE postgres=# \d+ defonwithoutoids Table "public.defonwithoutoids" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- a | integer | | plain | | postgres=# \d+ defonwithoids Table "public.defonwithoids" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- a | integer | | plain | | Has OIDs: yes . . . . postgres=# select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 9.5devel on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit (1 row) . . . ~$ /opt/postgres/bin/psql -V psql (PostgreSQL) 9.5devel