Mega Code Archive

 

Categories / PostgreSQL / Postgre SQL

 

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=#