PostgreSQL

CREATE STATISTICS CREATE STATISTICS — define extended statisticsCREATE STATISTICS [ IF NOT EXISTS ] statistics_name[ statistics_kind [, … ] ) ]ON column_name, column_name [, …]FROM… Read More »PostgreSQL STATISTICS

CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPER — define a new foreign-data wrapper CREATE FOREIGN DATA WRAPPER name     [ HANDLER handler_function | NO… Read More »PostgreSQL FOREIGN DATA WRAPPER

CREATE CONVERSION CREATE CONVERSION — define a new encoding conversion CREATE [ DEFAULT ] CONVERSION nameFOR source_encoding TO dest_encoding FROM function_name CREATE CONVERSION defines a new… Read More »PostgreSQL CONVERSION

CREATE EXTENSION CREATE EXTENSION — install an extension CREATE EXTENSION [ IF NOT EXISTS ] extension_name     [ WITH ] [ SCHEMA schema_name ]             … Read More »PostgreSQL EXTENSION

CREATE SCHEMA CREATE SCHEMA — define a new schema CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ … ] ] CREATE SCHEMA AUTHORIZATION… Read More »PostgreSQL SCHEMA

CREATE USER MAPPING CREATE USER MAPPING — define a new mapping of a user to a foreign server CREATE USER MAPPING [ IF NOT EXISTS… Read More »PostgreSQL USER MAPPING

CREATE USER CREATE USER — define a new database role CREATE USER name [ [ WITH ] option [ … ] ] where option can… Read More »PostgreSQL USER

CREATE GROUP CREATE GROUP — define a new database role CREATE GROUP name [ [ WITH ] option [ … ] ]   where option… Read More »PostgreSQL GROUP

CREATE ROLE CREATE ROLE — define a new database role CREATE ROLE name [ [ WITH ] option [ … ] ]   where option… Read More »PostgreSQL ROLE

CREATE POLICY CREATE POLICY — define a new row level security policy for a table CREATE POLICY name ON table_name     [ AS { PERMISSIVE… Read More »PostgreSQL POLICY

CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace CREATE TABLESPACE tablespace_name     [ OWNER { new_owner | CURRENT_USER | SESSION_USER } ]     LOCATION… Read More »PostgreSQL TABLESPACE

CREATE SERVER CREATE SERVER — define a new foreign server CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE ‘server_type’ ] [ VERSION ‘server_version’… Read More »PostgreSQL SERVER