{"Entry":{"collection":"relopts","key":"table-oids","name":"oids","aliases":["compat.oids"],"metadata":{"aliases":["compat.oids"],"category":"Table compatibility options","content_hash":"dd9116eee7a5cd403acaf6ec189f28c664dda58a5d10a881db2b960939035bf7","imported_at":"2026-09-30T17:44:22.252501+08:00","name":"oids","name_zh":"oids","slug":"table-oids","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."}},"Definition":{"Collection":"relopts","Key":"table-oids","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"table-oids","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"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."],"facts":[{"label":"Applies to","value":"Historical table syntax"},{"label":"Value","value":"FALSE only"}],"related":[{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sections":[{"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."],"title":"Compatibility option"}],"signature":"WITH (OIDS = FALSE)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH"}]},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#SQL-CREATETABLE-PARMS-WITH"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"table-oids","SourceDatabase":"center","Version":"18","Locale":"en","Title":"oids","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.","BodyHTML":"\u003cp\u003eThis 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.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"81b367ace21860812f0ecd06e6c2ee325ac0d0a7d249c0912303cd38e7131211","Payload":{"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."],"related":[{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"sections":[{"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."],"title":"Compatibility option"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}