{"kind": "relopts", "major": "18", "item": {"slug": "table-oids", "name": "oids", "name_zh": "oids", "category": "Table compatibility options", "summary": "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.", "aliases": ["compat.oids"], "versions": {"10": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "TRUE / FALSE"}], "related": [{"url": "/docs/sql/create-table/?v=10", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 10.23", "label": "10.23", "major": "10", "channel": "historical", "revision": "4ff6f6193d91bf44fc701f657cc3295850bf786e42eafbfeed9f4879c3522613"}, "sources": [{"url": "/docs/10/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 10 English manual", "sha256": "6a9df6e68f8acd82ca864475616f6c1cf483c97f96abfc2c2abd565aeb4129a5"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = TRUE | FALSE)", "description": ["This clause specifies optional storage parameters for a table or index; see Storage Parameters for more information. The WITH clause for a table can also include OIDS=TRUE (or just OIDS ) to specify that rows of the new table should have OIDs (object identifiers) assigned to them, or OIDS=FALSE to specify that the rows should not have OIDs. If OIDS is not specified, the default setting depends upon the default_with_oids configuration parameter. (If the new table inherits from any tables that have OIDs, then OIDS=TRUE is forced even if the command says OIDS=FALSE .)", "If OIDS=FALSE is specified or implied, the new table does not store OIDs and no OID will be assigned for a row inserted into it. This is generally considered worthwhile, since it will reduce OID consumption and thereby postpone the wraparound of the 32-bit OID counter. Once the counter wraps around, OIDs can no longer be assumed to be unique, which makes them considerably less useful. In addition, excluding OIDs from a table reduces the space required to store the table on disk by 4 bytes per row (on most machines), slightly improving performance.", "To remove OIDs from a table after it has been created, use ALTER TABLE ."]}, "11": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "TRUE / FALSE"}], "related": [{"url": "/docs/sql/create-table/?v=11", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 11.22", "label": "11.22", "major": "11", "channel": "historical", "revision": "284f2186559443efefbb1ea3b00740c25dccd01e540ecbdb81dadf5127e54a0b"}, "sources": [{"url": "/docs/11/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 11 English manual", "sha256": "46282e6bc95b6c42283c9fe7b79c31be21cafaa5a18dda82b7793cd21f400075"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = TRUE | FALSE)", "description": ["This clause specifies optional storage parameters for a table or index; see Storage Parameters for more information. The WITH clause for a table can also include OIDS=TRUE (or just OIDS ) to specify that rows of the new table should have OIDs (object identifiers) assigned to them, or OIDS=FALSE to specify that the rows should not have OIDs. If OIDS is not specified, the default setting depends upon the default_with_oids configuration parameter. (If the new table inherits from any tables that have OIDs, then OIDS=TRUE is forced even if the command says OIDS=FALSE .)", "If OIDS=FALSE is specified or implied, the new table does not store OIDs and no OID will be assigned for a row inserted into it. This is generally considered worthwhile, since it will reduce OID consumption and thereby postpone the wraparound of the 32-bit OID counter. Once the counter wraps around, OIDs can no longer be assumed to be unique, which makes them considerably less useful. In addition, excluding OIDs from a table reduces the space required to store the table on disk by 4 bytes per row (on most machines), slightly improving performance.", "To remove OIDs from a table after it has been created, use ALTER TABLE ."]}, "12": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=12", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 12.22", "label": "12.22", "major": "12", "channel": "historical", "revision": "0a1032bc0c23478646e9ee7d36edb066dca27b8540fd64d7fd47dcb6a8a6ccb4"}, "sources": [{"url": "/docs/12/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 12 English manual", "sha256": "7210cf3ff82ffa37ef81ebbbc252e4807649dcb86050eaa3ea5fcba40a768656"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "description": ["This clause specifies optional storage parameters for a table or index; see Storage Parameters 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."]}, "13": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=13", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 13.23", "label": "13.23", "major": "13", "channel": "historical", "revision": "346825c2d5fbebb2bd997afbb2d49edfd782dce050c0b934e84a883e5446a99f"}, "sources": [{"url": "/docs/13/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 13 English manual", "sha256": "912dd15faaa243438f33082160f2848636d1940afea42c36cf6d21a2a46c8cb8"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "14": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=14", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 14.24", "label": "14.24", "major": "14", "channel": "stable", "revision": "b6e7ed6d017bf1d63aae215156cde763babd657199df9fa10123733290c31260"}, "sources": [{"url": "/docs/14/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 14 English manual", "sha256": "2d92d1040e37f5d94ce279dc9f1555a720179397fcf3aa8412f5278ec1d943e8"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "15": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=15", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 15.19", "label": "15.19", "major": "15", "channel": "stable", "revision": "643ecd492fa284d4d55861f15cbd7c0c7451abce96c8d56485bb2729caba37d5"}, "sources": [{"url": "/docs/15/sql-createtable.html", "path": "sql-createtable.html", "label": "PostgreSQL 15 English manual", "sha256": "dcb246be9d6131c7227ccde6745458865a0c97ac4c8891c2cbea73a30769d6df"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "16": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=16", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 16.15", "label": "16.15", "major": "16", "channel": "stable", "revision": "0080d7d37081f27216dc4aa4f6ad85ea24c0c0441e702e6d0b190a339fd76f62"}, "sources": [{"url": "/docs/16/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 16 English manual", "sha256": "dde6108abda6f7358eeccc6867eb68f5ca601329ea3f50bc3d5b728c944a65a8"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "17": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=17", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 17.11", "label": "17.11", "major": "17", "channel": "stable", "revision": "440f894c3464e7cb4fedc9846b948ca21cd2ffcef1697ff56a28eb641ee7c3d8"}, "sources": [{"url": "/docs/17/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 17 English manual", "sha256": "97385c16a0ff155ad89fe616bb074bf0a8328bcb21f5e64a7a6a0a03ddb1f4ef"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "18": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=18", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 18 English manual", "sha256": "b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "19": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=19", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 19 beta 4", "label": "19 beta 4", "major": "19", "channel": "preview", "revision": "df6d20830d1a09734a2db6ffc3a6138ce80e669294e56a30f6b5d4a89d81aef1"}, "sources": [{"url": "/docs/19/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 19 English manual", "sha256": "75f290d105bd0e76c798f124b1eed4ad1e871c8a1d36c35f0db9d38fbb7209f8"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "20": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=20", "label": "CREATE TABLE"}], "release": {"ref": "2c10c2ce4d7bcd57543a49ab402af02a39724e0a", "label": "20 devel", "major": "20", "channel": "devel", "revision": "ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"}, "sources": [{"url": "/docs/devel/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 20 English manual", "sha256": "5241bd673de4e7a8fec7db6fa2a3a50d8368965206170725c4efd15d64c3fbf2"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}}, "content_hash": "667d82b953fedd024c0bcb44cd9e599825ca5d8410d1fc0a450ec74af0c2748e", "imported_at": "2026-09-27T09:57:58.964"}, "snapshot": {"facts": [{"label": "Applies to", "value": "Historical table syntax"}, {"label": "Value", "value": "FALSE only"}], "related": [{"url": "/docs/sql/create-table/?v=18", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH", "path": "sql-createtable.html", "label": "PostgreSQL 18 English manual", "sha256": "b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b"}], "sections": [{"title": "Compatibility option", "paragraphs": ["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."]}], "signature": "WITH (OIDS = FALSE)", "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."]}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}