| Server IP : 104.21.25.180 / Your IP : 104.23.197.122 Web Server : Apache/2.4.37 System : Linux almalinux.duckdns.org 4.18.0-553.111.1.el8_10.x86_64 #1 SMP Sun Mar 8 20:06:07 EDT 2026 x86_64 User : ricodeal ( 1046) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-docs/html/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>51.84. pg_sequences</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="[email protected]" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="view-pg-seclabels.html" title="51.83. pg_seclabels" /><link rel="next" href="view-pg-settings.html" title="51.85. pg_settings" /></head><body><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">51.84. <code xmlns="http://www.w3.org/1999/xhtml" class="structname">pg_sequences</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="view-pg-seclabels.html" title="51.83. pg_seclabels">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="catalogs.html" title="Chapter 51. System Catalogs">Up</a></td><th width="60%" align="center">Chapter 51. System Catalogs</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 10.23 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="view-pg-settings.html" title="51.85. pg_settings">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="VIEW-PG-SEQUENCES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">51.84. <code class="structname">pg_sequences</code></h2></div></div></div><a id="id-1.10.4.86.2" class="indexterm"></a><p> The view <code class="structname">pg_sequences</code> provides access to
useful information about each sequence in the database.
</p><div class="table" id="id-1.10.4.86.4"><p class="title"><strong>Table 51.85. <code class="structname">pg_sequences</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_sequences Columns" border="1"><colgroup><col /><col /><col /><col /></colgroup><thead><tr><th>Name</th><th>Type</th><th>References</th><th>Description</th></tr></thead><tbody><tr><td><code class="structfield">schemaname</code></td><td><code class="type">name</code></td><td><code class="literal"><a class="link" href="catalog-pg-namespace.html" title="51.32. pg_namespace"><code class="structname">pg_namespace</code></a>.nspname</code></td><td>Name of schema containing sequence</td></tr><tr><td><code class="structfield">sequencename</code></td><td><code class="type">name</code></td><td><code class="literal"><a class="link" href="catalog-pg-class.html" title="51.11. pg_class"><code class="structname">pg_class</code></a>.relname</code></td><td>Name of sequence</td></tr><tr><td><code class="structfield">sequenceowner</code></td><td><code class="type">name</code></td><td><code class="literal"><a class="link" href="catalog-pg-authid.html" title="51.8. pg_authid"><code class="structname">pg_authid</code></a>.rolname</code></td><td>Name of sequence's owner</td></tr><tr><td><code class="structfield">data_type</code></td><td><code class="type">regtype</code></td><td><code class="literal"><a class="link" href="catalog-pg-authid.html" title="51.8. pg_authid"><code class="structname">pg_type</code></a>.oid</code></td><td>Data type of the sequence</td></tr><tr><td><code class="structfield">start_value</code></td><td><code class="type">bigint</code></td><td> </td><td>Start value of the sequence</td></tr><tr><td><code class="structfield">min_value</code></td><td><code class="type">bigint</code></td><td> </td><td>Minimum value of the sequence</td></tr><tr><td><code class="structfield">max_value</code></td><td><code class="type">bigint</code></td><td> </td><td>Maximum value of the sequence</td></tr><tr><td><code class="structfield">increment_by</code></td><td><code class="type">bigint</code></td><td> </td><td>Increment value of the sequence</td></tr><tr><td><code class="structfield">cycle</code></td><td><code class="type">boolean</code></td><td> </td><td>Whether the sequence cycles</td></tr><tr><td><code class="structfield">cache_size</code></td><td><code class="type">bigint</code></td><td> </td><td>Cache size of the sequence</td></tr><tr><td><code class="structfield">last_value</code></td><td><code class="type">bigint</code></td><td> </td><td>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 <code class="literal">USAGE</code>
or <code class="literal">SELECT</code> privilege on the sequence, the value is
null.</td></tr></tbody></table></div></div><br class="table-break" /></div><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navfooter"><hr></hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="view-pg-seclabels.html" title="51.83. pg_seclabels">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="catalogs.html" title="Chapter 51. System Catalogs">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="view-pg-settings.html" title="51.85. pg_settings">Next</a></td></tr><tr><td width="40%" align="left" valign="top">51.83. <code xmlns="http://www.w3.org/1999/xhtml" class="structname">pg_seclabels</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 10.23 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 51.85. <code xmlns="http://www.w3.org/1999/xhtml" class="structname">pg_settings</code></td></tr></table></div></body></html>