Closed nene closed 3 months ago
TEMPORARY | TEMP
UNLOGGED
IF NOT EXISTS
name
AS data_type
INCREMENT [ BY ] increment
MINVALUE minvalue | NO MINVALUE
MAXVALUE maxvalue | NO MAXVALUE
START [ WITH ] start
RESTART [[ WITH ] restart]
CACHE cache
[ NO ] CYCLE
OWNED BY { table_name.column_name | NONE }
IF EXISTS
SET { LOGGED | UNLOGGED }
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
RENAME TO new_name
SET SCHEMA new_schema
name [, ...]
CASCADE | RESTRICT
TEMPORARY | TEMP
UNLOGGED
IF NOT EXISTS
name
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 }
IF EXISTS
name
SET { LOGGED | UNLOGGED }
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
RENAME TO new_name
SET SCHEMA new_schema
IF EXISTS
name [, ...]
CASCADE | RESTRICT