Sequences in schema in PostgreSQL database

Node displays information about sequences in a schema in a PostgreSQL database

PostgreSQL sequence list.jpg
  • Copy name - copy sequence name to clipboard

  • currentval  - form a command to get the current value of the sequence

  • Nextval  - form a command to get the next sequence number

  • Rename to - generate a command to rename a sequence

  • Owner to - generate a command to change the owner of the sequence

  • Set schema - generate a command to move a sequence to another schema in the current database

  • Get DDL - generate sequence creation code

  • Drop sequence - generate a command to delete a sequence

Sequence list

select s.sequence_name,
  from information_schema.sequences s
where  s.sequence_schema=$$SCHEMANAME