Documentation / Storage Parameters / Table compatibility options
oids
oids
This clause specifies optional storage parameters for a table or index; see Storage Parameters below for more information. For backward-compatibility the WITH clause for a table can also include OIDS=FALSE to specify that rows of the new table should not contain OIDs (object identifiers), OIDS=TRUE is not supported anymore.
Reading PostgreSQL 18.6.
Description
This clause specifies optional storage parameters for a table or index; see Storage Parameters below for more information. For backward-compatibility the WITH clause for a table can also include OIDS=FALSE to specify that rows of the new table should not contain OIDs (object identifiers), OIDS=TRUE is not supported anymore.
- Applies to
- Historical table syntax
- Value
- FALSE only
Usage
WITH (OIDS = FALSE)Compatibility option
This is historical CREATE TABLE row-OID syntax. It is not a physical tuning parameter stored in pg_class.reloptions. Allowed values depend on the selected version.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- Local English manual 18.6
- Source fingerprint
eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Back to Storage Parameters · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.