Open nene opened 3 months ago
OR REPLACE
CONSTRAINT
BEFORE | AFTER | INSTEAD OF
event [ OR ... ]
INSERT
UPDATE [ OF column_name [, ... ] ]
DELETE
TRUNCATE
ON table_name
FROM referenced_table_name
NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ]
REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ]
FOR [ EACH ] { ROW | STATEMENT }
WHEN ( condition )
EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments )
ON event
WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ]
EXECUTE { FUNCTION | PROCEDURE } function_name()
name ON table_name
RENAME TO new_name
[ NO ] DEPENDS ON EXTENSION extension_name
name
DISABLE
ENABLE [ REPLICA | ALWAYS ]
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
IF EXISTS
CASCADE | RESTRICT
OR REPLACE
CONSTRAINT
BEFORE | AFTER | INSTEAD OF
event [ OR ... ]
INSERT
UPDATE [ OF column_name [, ... ] ]
DELETE
TRUNCATE
ON table_name
FROM referenced_table_name
NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ]
REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ]
FOR [ EACH ] { ROW | STATEMENT }
WHEN ( condition )
EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments )
ON event
WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ]
EXECUTE { FUNCTION | PROCEDURE } function_name()
name ON table_name
RENAME TO new_name
[ NO ] DEPENDS ON EXTENSION extension_name
name
DISABLE
ENABLE [ REPLICA | ALWAYS ]
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
RENAME TO new_name
IF EXISTS
name ON table_name
CASCADE | RESTRICT