blob: b70be17f48dced3016176f21dbd2e497875c4894 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
<?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>52.85. pg_sequences</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="view-pg-seclabels.html" title="52.84. pg_seclabels" /><link rel="next" href="view-pg-settings.html" title="52.86. pg_settings" /></head><body id="docContent" class="container-fluid col-10"><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">52.85. <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="52.84. pg_seclabels">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="catalogs.html" title="Chapter 52. System Catalogs">Up</a></td><th width="60%" align="center">Chapter 52. System Catalogs</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 14.5 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="view-pg-settings.html" title="52.86. 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">52.85. <code class="structname">pg_sequences</code></h2></div></div></div><a id="id-1.10.4.87.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.87.4"><p class="title"><strong>Table 52.86. <code class="structname">pg_sequences</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_sequences Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
Column Type
</p>
<p>
Description
</p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">schemaname</code> <code class="type">name</code>
(references <a class="link" href="catalog-pg-namespace.html" title="52.32. pg_namespace"><code class="structname">pg_namespace</code></a>.<code class="structfield">nspname</code>)
</p>
<p>
Name of schema containing sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">sequencename</code> <code class="type">name</code>
(references <a class="link" href="catalog-pg-class.html" title="52.11. pg_class"><code class="structname">pg_class</code></a>.<code class="structfield">relname</code>)
</p>
<p>
Name of sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">sequenceowner</code> <code class="type">name</code>
(references <a class="link" href="catalog-pg-authid.html" title="52.8. pg_authid"><code class="structname">pg_authid</code></a>.<code class="structfield">rolname</code>)
</p>
<p>
Name of sequence's owner
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">data_type</code> <code class="type">regtype</code>
(references <a class="link" href="catalog-pg-type.html" title="52.62. pg_type"><code class="structname">pg_type</code></a>.<code class="structfield">oid</code>)
</p>
<p>
Data type of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">start_value</code> <code class="type">int8</code>
</p>
<p>
Start value of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">min_value</code> <code class="type">int8</code>
</p>
<p>
Minimum value of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">max_value</code> <code class="type">int8</code>
</p>
<p>
Maximum value of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">increment_by</code> <code class="type">int8</code>
</p>
<p>
Increment value of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">cycle</code> <code class="type">bool</code>
</p>
<p>
Whether the sequence cycles
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">cache_size</code> <code class="type">int8</code>
</p>
<p>
Cache size of the sequence
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">last_value</code> <code class="type">int8</code>
</p>
<p>
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.
</p></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="52.84. pg_seclabels">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="catalogs.html" title="Chapter 52. System Catalogs">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="view-pg-settings.html" title="52.86. pg_settings">Next</a></td></tr><tr><td width="40%" align="left" valign="top">52.84. <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 14.5 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 52.86. <code xmlns="http://www.w3.org/1999/xhtml" class="structname">pg_settings</code></td></tr></table></div></body></html>
|
