remove database objects owned by a database role NAME DROP_OWNED - remove database objects owned by a database role SYNOPSIS DROP OWNED BY { name | CURREN......COMPATIBILITY The REASSIGN OWNED command is a PostgreSQL extension. SEE ALSO DROP OWNED ( DROP_OWNED (7)), DROP ROLE ( DROP_ROLE (7)), ALTER DATABASE ( ALTER_DATABASE (7))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 schema NAME CREATE_SCHEMA - define a new schema SYNOPSIS CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHOR…define a new sequence generator NAME CREATE_SEQUENCE - define a new sequence generator SYNOPSIS CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] name [ AS data…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…change the definition of a sequence generator NAME ALTER_SEQUENCE - change the definition of a sequence generator SYNOPSIS ALTER SEQUENCE [ IF EXISTS ] name [ AS data_type ] [ INCR…install an extension NAME CREATE_EXTENSION - install an extension SYNOPSIS CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ C…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 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 …create a new database NAME CREATE_DATABASE - create a new database SYNOPSIS CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding …define default access privileges NAME ALTER_DEFAULT_PRIVILEGES - define default access privileges SYNOPSIS ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN…rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …define extended statistics NAME CREATE_STATISTICS - define extended statistics SYNOPSIS CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON ( expression ) FROM table_name CR…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 (…define access privileges NAME GRANT - define access privileges SYNOPSIS GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ P…remove a routine NAME DROP_ROUTINE - remove a routine SYNOPSIS DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DE…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…remove an index NAME DROP_INDEX - remove an index SYNOPSIS DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION DROP INDEX drops an existing in…remove a function NAME DROP_FUNCTION - remove a function SYNOPSIS DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT …