change the definition of a collation NAME ALTER_COLLATION - change the definition of a collation SYNOPSIS ALTER COLLATION name REFRESH VERSION ALTE......upgrade for copying the version from an existing installation. See also ALTER COLLATION ( ALTER_COLLATION (7)) for how to handle collation version mismatches. existing_collation…create a new database NAME CREATE_DATABASE - create a new database SYNOPSIS CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding …...rt from the IF EXISTS option, which is a PostgreSQL extension. SEE ALSO ALTER COLLATION ( ALTER_COLLATION (7)), CREATE COLLATION ( CREATE_COLLATION (7))change a database NAME ALTER_DATABASE - change a database SYNOPSIS ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option can be: ALLOW_CONNECTIONS allowconn CONNECTION LIMIT…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 domain NAME CREATE_DOMAIN - define a new domain SYNOPSIS CREATE DOMAIN name [ AS ] data_type [ COLLATE collation ] [ DEFAULT expression ] [ domain_constraint [ ... ] ]…change the definition of a type NAME ALTER_TYPE - change the definition of a type SYNOPSIS ALTER TYPE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ALTER…change the definition of a foreign table NAME ALTER_FOREIGN_TABLE - change the definition of a foreign table SYNOPSIS ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action […define a new foreign table NAME CREATE_FOREIGN_TABLE - define a new foreign table SYNOPSIS CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS (…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 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 data type NAME CREATE_TYPE - define a new data type SYNOPSIS CREATE TYPE name AS ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS EN…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 publication NAME CREATE_PUBLICATION - define a new publication SYNOPSIS CREATE PUBLICATION name [ FOR ALL TABLES | FOR publication_object [, ... ] ] [ WITH ( publicati…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 [, ...] )…define access privileges NAME GRANT - define access privileges SYNOPSIS GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ P…change the definition of a routine NAME ALTER_ROUTINE - change the definition of a routine SYNOPSIS ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ …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 …change a database role NAME ALTER_USER - change a database role SYNOPSIS ALTER USER role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATE…