begriffs open source - ai-pg/blob - full-docs/src/sgml/html/infoschema-sequences.html

   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>35.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="35.46. schemata" /><link rel="next" href="infoschema-sql-features.html" title="35.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">35.47. <code class="literal">sequences</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="infoschema-schemata.html" title="35.46. schemata">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="information-schema.html" title="Chapter 35. The Information Schema">Up</a></td><th width="60%" align="center">Chapter 35. The Information Schema</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="infoschema-sql-features.html" title="35.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">35.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 sequences
   4    defined in the current database.  Only those sequences are shown
   5    that the current user has access to (by way of being the owner or
   6    having some privilege).
   7   </p><div class="table" id="id-1.7.6.51.3"><p class="title"><strong>Table 35.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 Type
   9       </p>
  10       <p>
  11        Description
  12       </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 sequence
  22       </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 sequence
  27       </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 of
  37        the sequence data type (see above).  The precision indicates
  38        the number of significant digits.  It can be expressed in
  39        decimal (base 10) or binary (base 2) terms, as specified in the
  40        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 columns
  46        <code class="literal">numeric_precision</code> and
  47        <code class="literal">numeric_scale</code> are expressed.  The value is
  48        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 the
  54        sequence data type (see above).  The scale indicates the number
  55        of significant digits to the right of the decimal point.  It
  56        can be expressed in decimal (base 10) or binary (base 2) terms,
  57        as specified in the column
  58        <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 sequence
  64       </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 sequence
  69       </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 sequence
  74       </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 sequence
  79       </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="35.46. schemata">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="information-schema.html" title="Chapter 35. The Information Schema">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="infoschema-sql-features.html" title="35.48. sql_features">Next</a></td></tr><tr><td width="40%" align="left" valign="top">35.46. <code class="literal">schemata</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 35.48. <code class="literal">sql_features</code></td></tr></table></div></body></html>