See the fileNAME ALTER_TABLE - change the definition of a table SYNOPSIS ALTER TABLE [ IF EXISTS ] [ ONLY ... name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ …NAME CREATE_TABLE - define a new table SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE ... EXISTS ] table_name ( [ { column_name data_type [ STORAGE { …NAME ALTER_FOREIGN_TABLE - change the definition of a foreign table SYNOPSIS ALTER FOREIGN TABLE ... EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] …NAME SELECT, TABLE, WITH - retrieve rows from a table or view SYNOPSIS [ WITH [ RECURSIVE ] with ... from_item can be one of: [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_al…NAME CREATE_FOREIGN_TABLE - define a new foreign table SYNOPSIS CREATE FOREIGN TABLE ... EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option ' value ' [, ... ] ) ] […NAME CREATE_TABLE_AS - define a new table from the results of a query SYNOPSIS ... CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name …insert, update, or delete rows of a table SYNOPSIS [ WITH with_query [, ...] ] MERGE INTO [ ONLY ... target_table_name [ * ] [ [ AS ] target_alias ] USING data_source ON join_condi…CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { column_name | ( expression ) } [ COLLATE ... specified relation, which can be a table or a mat…REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | SYSTEM ... data store…NAME UPDATE - update rows of a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] UPDATE [ ONLY ] table ... There are two ways to modify a table using information contained i…optionally analyze a database SYNOPSIS VACUUM [ ( option [, ...] ) ] [ table_and_columns [, ...] ] where option ... STATS [ boolean ] BUFFER_USAGE_LIMIT size and table_and_columns …NAME LOCK - lock a table SYNOPSIS LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ] where ... EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE DESCRIPTION LOCK TAB…BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON table_name [ FROM referenced_table_name ] [ NOT DEFERRABLE ... INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ] [ REFERENCING { { …NAME INSERT - create new rows in a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO ... table_name [ AS alias ] [ ( column_name [, ...] ) ] [ OVERRIDING { SYSTE…NAME CLUSTER - cluster a table according to an index SYNOPSIS CLUSTER [ ( option [, ...] ) ] [ table_name [ USING ... DESCRIPTION CLUSTER instructs PostgreSQL to cluster the table …copy data between a file and a table SYNOPSIS COPY table_name [ ( column_name [, ...] ) ] FROM ... command ' | STDIN } [ [ WITH ] ( option [, ...] ) ] [ WHERE condition ] COPY { ta…value ] [, ... ] ) ] where publication_object is one of: TABLE table_and_columns [, ... ] TABLES IN SCHEMA { schema ... name | CURRENT_SCHEMA } [, ... ] and table_and_columns is: […statistics about a database SYNOPSIS ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] where option ... LOCKED [ boolean ] BUFFER_USAGE_LIMIT size and table_and_columns …NAME SELECT_INTO - define a new table from the results of a query SYNOPSIS [ WITH ... output_name ] } [, ...] ] INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] new_table [ FROM from…