Postgre SQL PostgreSQL

  1. Home
  2. PostgreSQL
  3. Postgre SQL
  4. 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=#