Топ-100
 
CerebroSQL

Sequences in schema in PostgreSQL database

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

PostgreSQL sequence list.jpg
Menu
  • 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
Pane

select s.sequence_name,
       s.data_type,
       s.numeric_precision,
       s.numeric_precision_radix,
       s.numeric_scale,
       s.start_value,
       s.minimum_value,
       s.maximum_value,
       s.increment,
       s.cycle_option
  from information_schema.sequences s
where  s.sequence_schema=$$SCHEMANAME