{"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":"e7ddefd2285cc2c70e8f1cd726d8371f24b0a07a1f7f1cfba650befabf5b0f19","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":"english-manuals:6c619e6ed6d05bb582e100827521bcc8cc5659fb66e4190d25d2010a4206fc90","summary":"The view pg_sequences provides access to useful information about each sequence in the database.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_sequences","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_sequences","SourceRevision":"english-manuals:6c619e6ed6d05bb582e100827521bcc8cc5659fb66e4190d25d2010a4206fc90","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},{"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},{"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},{"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},{"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},{"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},{"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},{"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},{"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},{"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},{"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}],"description":"The view pg_sequences provides access to useful information about each sequence in the database.","description_zh":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.28.4","file":"view-pg-sequences.html","lang":"en","sha256":"effe7e7207e6d9fcd3b7c2bed641a0e81cf3ffe3158fd23e07fecd5245f4b482","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_sequences","Summary":"视图pg_sequences提供对数据库中每个序列的有用信息的访问。","BodyHTML":"\u003cp\u003e视图pg_sequences提供对数据库中每个序列的有用信息的访问。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"10966a5386431432cd8b18ec5bf3b831b6f3744f9770aaa10ebbd59b85340517","Payload":{"columns":[{"description_zh":"包含该序列的模式名称","name":"schemaname","type":"name","zh_from":"doc"},{"description_zh":"序列名称","name":"sequencename","type":"name","zh_from":"doc"},{"description_zh":"序列拥有者名称","name":"sequenceowner","type":"name","zh_from":"doc"},{"description_zh":"序列的数据类型","name":"data_type","type":"regtype","zh_from":"doc"},{"description_zh":"序列的起始值","name":"start_value","type":"bigint","zh_from":"doc"},{"description_zh":"序列的最小值","name":"min_value","type":"bigint","zh_from":"doc"},{"description_zh":"序列的最大值","name":"max_value","type":"bigint","zh_from":"doc"},{"description_zh":"序列的增量值","name":"increment_by","type":"bigint","zh_from":"doc"},{"description_zh":"该序列是否循环","name":"cycle","type":"boolean","zh_from":"doc"},{"description_zh":"该序列的缓存大小","name":"cache_size","type":"bigint","zh_from":"doc"},{"description_zh":"写入磁盘的最后一个序列值。如果使用缓存，该值可能大于该序列最后发出的值。","name":"last_value","type":"bigint","zh_from":"doc"}],"description_zh":"视图pg_sequences提供对数据库中每个序列的有用信息的访问。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}