Skip to content

Postgres support (sequences) #66

@nene

Description

@nene
  • CREATE SEQUENCE
    • TEMPORARY | TEMP
    • UNLOGGED
    • IF NOT EXISTS
    • name
    • sequence options:
      • AS data_type
      • INCREMENT [ BY ] increment
      • MINVALUE minvalue | NO MINVALUE
      • MAXVALUE maxvalue | NO MAXVALUE
      • START [ WITH ] start
      • RESTART [[ WITH ] restart] (only really usable for ALTER SEQUENCE)
      • CACHE cache
      • [ NO ] CYCLE
      • OWNED BY { table_name.column_name | NONE }
  • ALTER SEQUENCE
    • IF EXISTS
    • name
    • sequence options
    • SET { LOGGED | UNLOGGED }
    • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
    • RENAME TO new_name
    • SET SCHEMA new_schema
  • DROP SEQUENCE
    • IF EXISTS
    • name [, ...]
    • CASCADE | RESTRICT

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions