\ds [ PATTERN ]
The \ds [ PATTERN ]
meta-command (lowercase s) returns a list of sequences and their parameters.
The following series of commands creates a sequence called my_seq and uses the vsql command to display its parameters:
=> CREATE SEQUENCE my_seq MAXVALUE 5000 START 150; CREATE SEQUENCE => \ds List of Sequences Schema | Sequence | CurrentValue | IncrementBy | Minimum | Maximum | AllowCycle --------+----------+--------------+-------------+---------+---------+------------ public | my_seq | 149 | 1 | 1 | 5000 | f (1 row)
Note: You can return additional information about sequences by issuing SELECT * FROM SEQUENCES, as described in the SQL Reference Manual.