top of page
Волнистый абстрактный фон
CerebroSQL

Sequences in schema in PostgreSQL database

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

PostgreSQL sequence list
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

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

bottom of page