Command can be used to view all sequences in the currently connected database : Postgre SQL Command « Postgre SQL « PostgreSQL

1. PostgreSQL
2. Postgre SQL
3. Postgre SQL Command

Command can be used to view all sequences in the currently connected database

postgres=#
postgres=# -- \ds  command can be used to view all sequences in the currently connected database
postgres=#
postgres=# CREATE SEQUENCE myseq MINVALUE 0;
CREATE SEQUENCE
postgres=#
postgres=# \ds
          List of relations
 Schema | Name  |   Type   |  Owner
--------+-------+----------+----------
 public | myseq | sequence | postgres
(1 row)

postgres=#
postgres=#
postgres=# drop sequence myseq;
DROP SEQUENCE
postgres=#
postgres=#
           
       

Related examples in the same category