PostgreSQL System Columns

最新推荐文章于 2024-11-09 17:09:40 发布

ssky87

最新推荐文章于 2024-11-09 17:09:40 发布

阅读量537

点赞数

文章标签： postgresql system table command transactions database

本文链接：https://blog.csdn.net/ssky87/article/details/5935494

版权

PostgreSQL的每个表都包含一些由系统隐式定义的系统列，例如OIDs、事务标识符和命令标识符。虽然这些列的名字不能用作用户定义列的名称，但它们在数据库操作中扮演着特定角色。OIDs不保证全局唯一，建议使用序列生成器来标识行。对于跨表的唯一标识，可以结合tableoid和row OID。自PostgreSQL 8.1起，不推荐使用WITH OIDS创建表，因为WITHOUT OIDS已成为默认选项。此外，长期依赖交易ID的唯一性并不明智，因为它们可能会回绕。

摘要由CSDN通过智能技术生成

5.4. System Columns

Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns. (Note that these restrictions are separate from whether the name is a key word or not; quoting a name will not allow you to escape these restrictions.) You do not really need to be concerned about these columns, just know they exist.

oid

The object identifier (object ID) of a row. This column is only present if the table was created using WITH OIDS, or if the default_with_oids configuration variable was set at the time