Extended Syntax

Creating a table

column_constraint:

REFERENCES reftable

[ ( refcolumn ) ] [ MATCH

FULL | MATCH PARTIAL |

MATCH SIMPLE ][ ON

DELETE action ] [ ON

UPDATE action ]

You can run REFERENCES reftable[(refcolumn)] [MATCH FULL |MATCH PARTIAL | MATCH SIMPLE] [ON DELETE action] [ON UPDATE action] to create foreign key constraints for tables.

Loading a module

CREATE EXTENSION

Loads a new module to the current database. This feature is for internal use only. You are advised not to use it.

DROP EXTENSION

Deletes the loaded module. This feature is for internal use only. You are advised not to use it.

Aggregate functions

CREATE AGGREGATE

Defines a new aggregate function.

ALTER AGGREGATE

Modifies the definition of an aggregate function.

DROP AGGREGATE

Drops an existing function.