codekingpro/portable-devtools

1<?xml version="1.0" encoding="UTF-8" standalone="no"?>2<!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>37.47. 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="infoschema-schemata.html" title="37.46. schemata" /><link rel="next" href="infoschema-sql-features.html" title="37.48. sql_features" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">37.47. <code class="literal">sequences</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-schemata.html" title="37.46. schemata">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 37. The Information Schema</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-sql-features.html" title="37.48. sql_features">Next</a></td></tr></table><hr /></div><div class="sect1" id="INFOSCHEMA-SEQUENCES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">37.47. <code class="literal">sequences</code> <a href="#INFOSCHEMA-SEQUENCES" class="id_link">#</a></h2></div></div></div><p>3   The view <code class="literal">sequences</code> contains all sequences4   defined in the current database.  Only those sequences are shown5   that the current user has access to (by way of being the owner or6   having some privilege).7  </p><div class="table" id="id-1.7.6.51.3"><p class="title"><strong>Table 37.45. <code class="structname">sequences</code> Columns</strong></p><div class="table-contents"><table class="table" summary="sequences Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">8       Column Type9      </p>10      <p>11       Description12      </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">13       <code class="structfield">sequence_catalog</code> <code class="type">sql_identifier</code>14      </p>15      <p>16       Name of the database that contains the sequence (always the current database)17      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">18       <code class="structfield">sequence_schema</code> <code class="type">sql_identifier</code>19      </p>20      <p>21       Name of the schema that contains the sequence22      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">23       <code class="structfield">sequence_name</code> <code class="type">sql_identifier</code>24      </p>25      <p>26       Name of the sequence27      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">28       <code class="structfield">data_type</code> <code class="type">character_data</code>29      </p>30      <p>31       The data type of the sequence.32      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">33       <code class="structfield">numeric_precision</code> <code class="type">cardinal_number</code>34      </p>35      <p>36       This column contains the (declared or implicit) precision of37       the sequence data type (see above).  The precision indicates38       the number of significant digits.  It can be expressed in39       decimal (base 10) or binary (base 2) terms, as specified in the40       column <code class="literal">numeric_precision_radix</code>.41      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">42       <code class="structfield">numeric_precision_radix</code> <code class="type">cardinal_number</code>43      </p>44      <p>45       This column indicates in which base the values in the columns46       <code class="literal">numeric_precision</code> and47       <code class="literal">numeric_scale</code> are expressed.  The value is48       either 2 or 10.49      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">50       <code class="structfield">numeric_scale</code> <code class="type">cardinal_number</code>51      </p>52      <p>53       This column contains the (declared or implicit) scale of the54       sequence data type (see above).  The scale indicates the number55       of significant digits to the right of the decimal point.  It56       can be expressed in decimal (base 10) or binary (base 2) terms,57       as specified in the column58       <code class="literal">numeric_precision_radix</code>.59      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">60       <code class="structfield">start_value</code> <code class="type">character_data</code>61      </p>62      <p>63       The start value of the sequence64      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">65       <code class="structfield">minimum_value</code> <code class="type">character_data</code>66      </p>67      <p>68       The minimum value of the sequence69      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">70       <code class="structfield">maximum_value</code> <code class="type">character_data</code>71      </p>72      <p>73       The maximum value of the sequence74      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">75       <code class="structfield">increment</code> <code class="type">character_data</code>76      </p>77      <p>78       The increment of the sequence79      </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">80       <code class="structfield">cycle_option</code> <code class="type">yes_or_no</code>81      </p>82      <p>83       <code class="literal">YES</code> if the sequence cycles, else <code class="literal">NO</code>84      </p></td></tr></tbody></table></div></div><br class="table-break" /><p>85   Note that in accordance with the SQL standard, the start, minimum,86   maximum, and increment values are returned as character strings.87  </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="infoschema-schemata.html" title="37.46. schemata">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html" title="Chapter 37. The Information Schema">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-sql-features.html" title="37.48. sql_features">Next</a></td></tr><tr><td width="40%" align="left" valign="top">37.46. <code class="literal">schemata</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 37.48. <code class="literal">sql_features</code></td></tr></table></div></body></html>