Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
51.87. pg_sequences
Prev UpChapter 51. System CatalogsHome Next

51.87. pg_sequences

The viewpg_sequences provides access to useful information about each sequence in the database.

Table 51.88. pg_sequences Columns

Column Type

Description

schemanamename (referencespg_namespace.nspname)

Name of schema containing sequence

sequencenamename (referencespg_class.relname)

Name of sequence

sequenceownername (referencespg_authid.rolname)

Name of sequence's owner

data_typeregtype (referencespg_type.oid)

Data type of the sequence

start_valueint8

Start value of the sequence

min_valueint8

Minimum value of the sequence

max_valueint8

Maximum value of the sequence

increment_byint8

Increment value of the sequence

cyclebool

Whether the sequence cycles

cache_sizeint8

Cache size of the sequence

last_valueint8

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 haveUSAGE orSELECT privilege on the sequence, the value is null.



Prev Up Next
51.86. pg_seclabels Home 51.88. pg_settings
pdfepub
Go to Postgres Pro Standard 14
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp