\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.