define a new index NAME CREATE_INDEX - define a new index SYNOPSIS CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS......CREATE DATABASE ( CREATE_DATABASE (7)), CREATE TABLE ( CREATE_TABLE (7)), CREATE INDEX ( CREATE_INDEX (7)), DROP TABLESPACE ( DROP_TABLESPACE (7)), ALTER TABLESPACE ( ALTER_TABL…change a database NAME ALTER_DATABASE - change a database SYNOPSIS ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option can be: ALLOW_CONNECTIONS allowconn CONNECTION LIMIT…...LY option.) Each backend running REINDEX will report its progress in the pg_stat_progress_create_index view. See Section 27.4.4 for details. EXAMPLES Rebuild a single index: REI…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 […...ISTICS 1000; COMPATIBILITY ALTER INDEX is a PostgreSQL extension. SEE ALSO CREATE INDEX ( CREATE_INDEX (7)), REINDEX (7)create new rows in a table NAME INSERT - create new rows in a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] )…...tension. There are no provisions for indexes in the SQL standard. SEE ALSO CREATE INDEX ( CREATE_INDEX (7))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…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…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…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…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 …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 …garbage-collect and optionally analyze a database NAME VACUUM - garbage-collect and optionally analyze a database SYNOPSIS VACUUM [ ( option [, ...] ) ] [ table_and_columns [, ...]…define a new access method NAME CREATE_ACCESS_METHOD - define a new access method SYNOPSIS CREATE ACCESS METHOD name TYPE access_method_type HANDLER handler_function DESCRIPTION CR…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 operator class NAME ALTER_OPERATOR_CLASS - change the definition of an operator class SYNOPSIS ALTER OPERATOR CLASS name USING index_method RENAME TO ne…A tutorial introduction to Git: part two NAME gittutorial-2 - A tutorial introduction to Git: part two SYNOPSIS git * DESCRIPTION You should work through gittutorial (7) before rea…