{"Entry":{"collection":"catalog","key":"pg_sequences","name":"pg_sequences","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence. Null if the sequence has not been read from yet. Also, if the current user does not have USAGE or SELECT privilege on the sequence, the value is null.","name":"last_value","to":"The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence."}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]}],"column_count":11,"content_hash":"85c79b43e83c0e729700d424f8d6f13828e446af2d2c0b94b2730ed1ef9fa429","derived_content_hash":"8c651bb34220a696145044731f0b731c06ca705047c242c1b613befc00804812","first_version":"10","imported_at":"2026-09-30T00:40:55.799676+08:00","kind":"view","last_version":"20","name":"pg_sequences","position":73,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:0335ceb813951e41f69d59714bdd029ec8bdeedf740effa7287ebe58b0207ff6","summary":"The view pg_sequences provides access to useful information about each sequence in the database.","summary_zh":"视图 pg_sequences 提供对数据库中每个序列的有用信息的访问。"}},"Definition":{"Collection":"catalog","Key":"pg_sequences","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_sequences","SourceRevision":"catalog-bilingual-repair:0335ceb813951e41f69d59714bdd029ec8bdeedf740effa7287ebe58b0207ff6","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing sequence","description_zh":"包含该序列的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of sequence","description_zh":"序列名称","documented":true,"documented_name":"sequencename","hidden":false,"name":"sequencename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of sequence's owner","description_zh":"序列拥有者名称","documented":true,"documented_name":"sequenceowner","hidden":false,"name":"sequenceowner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Data type of the sequence","description_zh":"序列的数据类型","documented":true,"documented_name":"data_type","hidden":false,"name":"data_type","not_null":false,"references":"pg_type.oid","type":"regtype","type_modifier":-1,"type_oid":2206,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Start value of the sequence","description_zh":"序列的起始值","documented":true,"documented_name":"start_value","hidden":false,"name":"start_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Minimum value of the sequence","description_zh":"序列的最小值","documented":true,"documented_name":"min_value","hidden":false,"name":"min_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Maximum value of the sequence","description_zh":"序列的最大值","documented":true,"documented_name":"max_value","hidden":false,"name":"max_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Increment value of the sequence","description_zh":"序列的增量值","documented":true,"documented_name":"increment_by","hidden":false,"name":"increment_by","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Whether the sequence cycles","description_zh":"该序列是否循环","documented":true,"documented_name":"cycle","hidden":false,"name":"cycle","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Cache size of the sequence","description_zh":"该序列的缓存大小","documented":true,"documented_name":"cache_size","hidden":false,"name":"cache_size","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence.","description_zh":"写入磁盘的最后一个序列值。如果使用缓存，该值可能大于该序列最后发出的值。","documented":true,"documented_name":"last_value","hidden":false,"name":"last_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"The view pg_sequences provides access to useful information about each sequence in the database.","description_zh":"视图 pg_sequences 提供对数据库中每个序列的有用信息的访问。","description_zh_html":"\u003cp\u003e视图 pg_sequences 提供对数据库中每个序列的有用信息的访问。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.28.4","file":"view-pg-sequences.html","lang":"en","sha256":"effe7e7207e6d9fcd3b7c2bed641a0e81cf3ffe3158fd23e07fecd5245f4b482","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","sequencename","sequenceowner","data_type","start_value","min_value","max_value","increment_by","cycle","cache_size","last_value"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-sequences.html","sha256":"ee707c584c27fb9ac1fb832c698b0d27f6a93734128367273a40d8bdcc49c40c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:6c619e6ed6d05bb582e100827521bcc8cc5659fb66e4190d25d2010a4206fc90","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.28.4","file":"view-pg-sequences.html","lang":"en","sha256":"effe7e7207e6d9fcd3b7c2bed641a0e81cf3ffe3158fd23e07fecd5245f4b482","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-sequences.html","sha256":"ee707c584c27fb9ac1fb832c698b0d27f6a93734128367273a40d8bdcc49c40c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:6c619e6ed6d05bb582e100827521bcc8cc5659fb66e4190d25d2010a4206fc90","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","sequencename","sequenceowner","data_type","start_value","min_value","max_value","increment_by","cycle","cache_size","last_value"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_sequences","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_sequences","Summary":"The view pg_sequences provides access to useful information about each sequence in the database.","BodyHTML":"\u003cp\u003eThe view pg_sequences provides access to useful information about each sequence in the database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:0335ceb813951e41f69d59714bdd029ec8bdeedf740effa7287ebe58b0207ff6","ContentHash":"509ee1aeb465eb74da49ce652d2ea893e330360270687a4c0a3393a3a286ae61","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing sequence","description_zh":"包含该序列的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of sequence","description_zh":"序列名称","documented":true,"documented_name":"sequencename","hidden":false,"name":"sequencename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of sequence's owner","description_zh":"序列拥有者名称","documented":true,"documented_name":"sequenceowner","hidden":false,"name":"sequenceowner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Data type of the sequence","description_zh":"序列的数据类型","documented":true,"documented_name":"data_type","hidden":false,"name":"data_type","not_null":false,"references":"pg_type.oid","type":"regtype","type_modifier":-1,"type_oid":2206,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Start value of the sequence","description_zh":"序列的起始值","documented":true,"documented_name":"start_value","hidden":false,"name":"start_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Minimum value of the sequence","description_zh":"序列的最小值","documented":true,"documented_name":"min_value","hidden":false,"name":"min_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Maximum value of the sequence","description_zh":"序列的最大值","documented":true,"documented_name":"max_value","hidden":false,"name":"max_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Increment value of the sequence","description_zh":"序列的增量值","documented":true,"documented_name":"increment_by","hidden":false,"name":"increment_by","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Whether the sequence cycles","description_zh":"该序列是否循环","documented":true,"documented_name":"cycle","hidden":false,"name":"cycle","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Cache size of the sequence","description_zh":"该序列的缓存大小","documented":true,"documented_name":"cache_size","hidden":false,"name":"cache_size","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence.","description_zh":"写入磁盘的最后一个序列值。如果使用缓存，该值可能大于该序列最后发出的值。","documented":true,"documented_name":"last_value","hidden":false,"name":"last_value","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"The view pg_sequences provides access to useful information about each sequence in the database."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}