change the definition of an index NAME ALTER_INDEX - change the definition of an index SYNOPSIS ALTER INDEX [ IF EXISTS ] name RENAME TO new...define a new index NAME CREATE_INDEX - define a new index SYNOPSIS CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { c…define a new tablespace NAME CREATE_TABLESPACE - define a new tablespace SYNOPSIS CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER…change a database NAME ALTER_DATABASE - change a database SYNOPSIS ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option can be: ALLOW_CONNECTIONS allowconn CONNECTION LIMIT…remove an operator family NAME DROP_OPERATOR_FAMILY - remove an operator family SYNOPSIS DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTI…change the definition of an operator family NAME ALTER_OPERATOR_FAMILY - change the definition of an operator family SYNOPSIS ALTER OPERATOR FAMILY name USING index_method ADD { OP…change the definition of a table NAME ALTER_TABLE - change the definition of a table SYNOPSIS ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS …define a new operator family NAME CREATE_OPERATOR_FAMILY - define a new operator family SYNOPSIS CREATE OPERATOR FAMILY name USING index_method DESCRIPTION CREATE OPERATOR FAMILY c…remove an operator class NAME DROP_OPERATOR_CLASS - remove an operator class SYNOPSIS DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTION D…cluster a table according to an index NAME CLUSTER - cluster a table according to an index SYNOPSIS CLUSTER [ ( option [, ...] ) ] [ table_name [ USING index_name ] ] where option …rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …change the definition of an operator class NAME ALTER_OPERATOR_CLASS - change the definition of an operator class SYNOPSIS ALTER OPERATOR CLASS name USING index_method RENAME TO ne…change the definition of a tablespace NAME ALTER_TABLESPACE - change the definition of a tablespace SYNOPSIS ALTER TABLESPACE name RENAME TO new_name ALTER TABLESPACE name OWNER TO…define a new table NAME CREATE_TABLE - define a new table SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_nam…define a new operator class NAME CREATE_OPERATOR_CLASS - define a new operator class SYNOPSIS CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY …change the definition of an extension NAME ALTER_EXTENSION - change the definition of an extension SYNOPSIS ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET …change the definition of a materialized view NAME ALTER_MATERIALIZED_VIEW - change the definition of a materialized view SYNOPSIS ALTER MATERIALIZED VIEW [ IF EXISTS ] name action …show the execution plan of a statement NAME EXPLAIN - show the execution plan of a statement SYNOPSIS EXPLAIN [ ( option [, ...] ) ] statement where option can be one of: ANALYZE […remove a text search configuration NAME DROP_TEXT_SEARCH_CONFIGURATION - remove a text search configuration SYNOPSIS DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | R…change the definition of a collation NAME ALTER_COLLATION - change the definition of a collation SYNOPSIS ALTER COLLATION name REFRESH VERSION ALTER COLLATION name RENAME TO new_na…