<structfield>min_value</structfield> <type>int8</type>
</para>
<para>
Minimum value of the sequence
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>max_value</structfield> <type>int8</type>
</para>
<para>
Maximum value of the sequence
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>increment_by</structfield> <type>int8</type>
</para>
<para>
Increment value of the sequence
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>cycle</structfield> <type>bool</type>
</para>
<para>
Whether the sequence cycles
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>cache_size</structfield> <type>int8</type>
</para>
<para>
Cache size of the sequence
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>last_value</structfield> <type>int8</type>
</para>
<para>
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.
</para></entry>
</row>
</tbody>
</tgroup>
</table>
<para>
The <structfield>last_value</structfield> column will read as null if any of
the following are true:
<itemizedlist>
<listitem>
<para>
The sequence has not been read from yet.
</para>
</listitem>
<listitem>
<para>
The current user does not have <literal>USAGE</literal> or
<literal>SELECT</literal> privilege on the sequence.
</para>
</listitem>
<listitem>
<para>
The sequence is unlogged and the server is a standby.
</para>
</listitem>
</itemizedlist>
</para>
</sect1>
<sect1 id="view-pg-settings">
<title><structname>pg_settings</structname></title>
<indexterm zone="view-pg-settings">
<primary>pg_settings</primary>
</indexterm>
<para>
The view <structname>pg_settings</structname> provides access to
run-time parameters of the server. It is essentially an alternative
interface to the <link linkend="sql-show"><command>SHOW</command></link>
and <link linkend="sql-set"><command>SET</command></link> commands.
It also provides access to some facts about each parameter that are
not directly available from <link linkend="sql-show"><command>SHOW</command></link>, such as minimum and
maximum values.
</para>
<table>
<title><structname>pg_settings</structname> Columns</title>
<tgroup cols="1">
<thead>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
Column Type
</para>
<para>
Description
</para></entry>
</row>
</thead>
<tbody>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>name</structfield> <type>text</type>
</para>
<para>
Run-time configuration parameter name
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>setting</structfield> <type>text</type>
</para>
<para>
Current value of the parameter
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>unit</structfield> <type>text</type>
</para>
<para>
Implicit unit of the parameter
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>category</structfield> <type>text</type>
</para>
<para>