define a new publication NAME CREATE_PUBLICATION - define a new publication SYNOPSIS CREATE PUBLICATION name [ FOR ALL TABLES | FOR public......REATE_SUBSCRIPTION (7)), DROP SUBSCRIPTION ( DROP_SUBSCRIPTION (7)), CREATE PUBLICATION ( CREATE_PUBLICATION (7)), ALTER PUBLICATION ( ALTER_PUBLICATION (7))...e synopsis can change all of the publication properties specified in CREATE PUBLICATION ( CREATE_PUBLICATION (7)). Properties not mentioned in the command retain their previous …...ALTER_SUBSCRIPTION (7)), DROP SUBSCRIPTION ( DROP_SUBSCRIPTION (7)), CREATE PUBLICATION ( CREATE_PUBLICATION (7)), ALTER PUBLICATION ( ALTER_PUBLICATION (7))...; COMPATIBILITY DROP PUBLICATION is a PostgreSQL extension. SEE ALSO CREATE PUBLICATION ( CREATE_PUBLICATION (7)), ALTER PUBLICATION ( ALTER_PUBLICATION (7))define or change the comment of an object NAME COMMENT - define or change the comment of an object SYNOPSIS COMMENT ON { ACCESS METHOD object_name | AGGREGATE aggregate_name ( aggr…define or change a security label applied to an object NAME SECURITY_LABEL - define or change a security label applied to an object SYNOPSIS SECURITY LABEL [ FOR provider ] ON { TA…define a new schema NAME CREATE_SCHEMA - define a new schema SYNOPSIS CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHOR…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…define a new transform NAME CREATE_TRANSFORM - define a new transform SYNOPSIS CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_fu…define a new materialized view NAME CREATE_MATERIALIZED_VIEW - define a new materialized view SYNOPSIS CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ ( column_name [, ...]…define a new table from the results of a query NAME CREATE_TABLE_AS - define a new table from the results of a query SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNL…define a new foreign-data wrapper NAME CREATE_FOREIGN_DATA_WRAPPER - define a new foreign-data wrapper SYNOPSIS CREATE FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HAN…define a new database role NAME CREATE_USER - define a new database role SYNOPSIS CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATE…define a new collation NAME CREATE_COLLATION - define a new collation SYNOPSIS CREATE COLLATION [ IF NOT EXISTS ] name ( [ LOCALE = locale , ] [ LC_COLLATE = lc_collate , ] [ LC_CT…define a new database role NAME CREATE_GROUP - define a new database role SYNOPSIS CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREA…define a new mapping of a user to a foreign server NAME CREATE_USER_MAPPING - define a new mapping of a user to a foreign server SYNOPSIS CREATE USER MAPPING [ IF NOT EXISTS ] FOR …define a new encoding conversion NAME CREATE_CONVERSION - define a new encoding conversion SYNOPSIS CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM fun…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 foreign server NAME CREATE_SERVER - define a new foreign server SYNOPSIS CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE ' server_type ' ] [ VERSION ' server_versio…