define default access privileges NAME ALTER_DEFAULT_PRIVILEGES - define default access privileges SYNOPSIS ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER...change the ownership of database objects owned by a database role NAME REASSIGN_OWNED - change the ownership of database objects owned by a database role SYNOPSIS REASSIGN OWNED BY…change a database NAME ALTER_DATABASE - change a database SYNOPSIS ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option can be: ALLOW_CONNECTIONS allowconn CONNECTION LIMIT…set the current user identifier of the current session NAME SET_ROLE - set the current user identifier of the current session SYNOPSIS SET [ SESSION | LOCAL ] ROLE role_name SET [ …...ion parameters are PostgreSQL extensions. SEE ALSO REVOKE (7), ALTER DEFAULT PRIVILEGES ( ALTER_DEFAULT_PRIVILEGES (7))...ut PostgreSQL assumes RESTRICT by default. SEE ALSO GRANT (7), ALTER DEFAULT PRIVILEGES ( ALTER_DEFAULT_PRIVILEGES (7))change the definition of a schema NAME ALTER_SCHEMA - change the definition of a schema SYNOPSIS ALTER SCHEMA name RENAME TO new_name ALTER SCHEMA name OWNER TO { new_owner | CURRE…install an extension NAME CREATE_EXTENSION - install an extension SYNOPSIS CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ C…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…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 database role NAME CREATE_ROLE - define a new database role SYNOPSIS CREATE ROLE name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATE…define a new view NAME CREATE_VIEW - define a new view SYNOPSIS CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_…remove a database role NAME DROP_ROLE - remove a database role SYNOPSIS DROP ROLE [ IF EXISTS ] name [, ...] DESCRIPTION DROP ROLE removes the specified role(s). To drop a superuse…define a new procedure NAME CREATE_PROCEDURE - define a new procedure SYNOPSIS CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_ex…define a new subscription NAME CREATE_SUBSCRIPTION - define a new subscription SYNOPSIS CREATE SUBSCRIPTION subscription_name CONNECTION ' conninfo ' PUBLICATION publication_name […create a new database NAME CREATE_DATABASE - create a new database SYNOPSIS CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding …wrapper for PostgreSQL client commands NAME pg_wrapper - wrapper for PostgreSQL client commands SYNOPSIS client-program [ --cluster version / cluster ] [...] ( client-program : psq…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 function NAME CREATE_FUNCTION - define a new function SYNOPSIS CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ]…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 …