Search PostgreSQL documentation

DROP SUBSCRIPTIONManual ChaptersPG18DROP SUBSCRIPTION DROP SUBSCRIPTION — remove a subscription Synopsis DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP SUBSCRIPTION DROP SUBSCRIPTIONSQL CommandsReferenceDROP SUBSCRIPTION Logical Replication 10 remove a subscription DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP SUBSCRIPTION removes a subscription from the database cluster.…SQL Commands · Logical Replication DROP TABLEManual ChaptersPG18DROP TABLE DROP TABLE — remove a table Synopsis DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP TABLE DROP TABLESQL CommandsReferenceDROP TABLE Tables & Views 10 remove a table DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP TABLE removes tables from the database. Only the table owner, the schema owner, …SQL Commands · Tables & Views DROP TABLESPACEManual ChaptersPG18DROP TABLESPACE DROP TABLESPACE — remove a tablespace Synopsis DROP TABLESPACE [ IF EXISTS ] nameDROP TABLESPACE DROP TABLESPACESQL CommandsReferenceDROP TABLESPACE Databases & Schemas 10 remove a tablespace DROP TABLESPACE [ IF EXISTS ] name DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its ow…SQL Commands · Databases & Schemas DROP TEXT SEARCH CONFIGURATIONManual ChaptersPG18DROP TEXT SEARCH CONFIGURATION DROP TEXT SEARCH CONFIGURATION — remove a text search configuration Synopsis DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP TEXT SEARCH CONFIGURATION DROP TEXT SEARCH CONFIGURATIONSQL CommandsReferenceDROP TEXT SEARCH CONFIGURATION Text Search 10 remove a text search configuration DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH CONFIGURATION drops…SQL Commands · Text Search DROP TEXT SEARCH DICTIONARYManual ChaptersPG18DROP TEXT SEARCH DICTIONARY DROP TEXT SEARCH DICTIONARY — remove a text search dictionary Synopsis DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP TEXT SEARCH DICTIONARY DROP TEXT SEARCH DICTIONARYSQL CommandsReferenceDROP TEXT SEARCH DICTIONARY Text Search 10 remove a text search dictionary DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH DICTIONARY drops an existing…SQL Commands · Text Search DROP TEXT SEARCH PARSERManual ChaptersPG18DROP TEXT SEARCH PARSER DROP TEXT SEARCH PARSER — remove a text search parser Synopsis DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP TEXT SEARCH PARSER DROP TEXT SEARCH PARSERSQL CommandsReferenceDROP TEXT SEARCH PARSER Text Search 10 remove a text search parser DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH PARSER drops an existing text search par…SQL Commands · Text Search DROP TEXT SEARCH TEMPLATEManual ChaptersPG18DROP TEXT SEARCH TEMPLATE DROP TEXT SEARCH TEMPLATE — remove a text search template Synopsis DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP TEXT SEARCH TEMPLATE DROP TEXT SEARCH TEMPLATESQL CommandsReferenceDROP TEXT SEARCH TEMPLATE Text Search 10 remove a text search template DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH TEMPLATE drops an existing text se…SQL Commands · Text Search DROP TRANSFORMManual ChaptersPG18DROP TRANSFORM DROP TRANSFORM — remove a transform Synopsis DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]DROP TRANSFORM DROP TRANSFORMSQL CommandsReferenceDROP TRANSFORM Functions & Procedures 10 remove a transform DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ] DROP TRANSFORM removes a previously defined t…SQL Commands · Functions & Procedures DROP TRIGGERManual ChaptersPG18DROP TRIGGER DROP TRIGGER — remove a trigger Synopsis DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP TRIGGER DROP TRIGGERSQL CommandsReferenceDROP TRIGGER Triggers & Rules 10 remove a trigger DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DROP TRIGGER removes an existing trigger definition. To execute this co…SQL Commands · Triggers & Rules DROP TYPEManual ChaptersPG18DROP TYPE DROP TYPE — remove a data type Synopsis DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP TYPE DROP TYPESQL CommandsReferenceDROP TYPE Types & Operators 10 remove a data type DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP TYPE removes a user-defined data type. Only the owner of a type can remove …SQL Commands · Types & Operators DROP USERManual ChaptersPG18DROP USER DROP USER — remove a database role Synopsis DROP USER [ IF EXISTS ] name [, ...]DROP USER DROP USERSQL CommandsReferenceDROP USER Roles & Privileges 10 remove a database role DROP USER [ IF EXISTS ] name [, ...] DROP USER is simply an alternate spelling of DROP ROLE . The DROP USER statement is a PostgreSQL e…SQL Commands · Roles & Privileges DROP USER MAPPINGManual ChaptersPG18DROP USER MAPPING DROP USER MAPPING — remove a user mapping for a foreign server Synopsis DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERV…DROP USER MAPPING DROP USER MAPPINGSQL CommandsReferenceDROP USER MAPPING Foreign Data 10 remove a user mapping for a foreign server DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name DROP USER MAP…SQL Commands · Foreign Data DROP VIEWManual ChaptersPG18DROP VIEW DROP VIEW — remove a view Synopsis DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP VIEW DROP VIEWSQL CommandsReferenceDROP VIEW Tables & Views 10 remove a view DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP VIEW drops an existing view. To execute this command you must be the owner of the v…SQL Commands · Tables & Views drop_role_helperExtensionsExtensionsGenerates SQL to revoke all privileges held by a role in the current database. privileges roles security drop_role_helper SecuritySecurity · Extensions dropdbCommand-line ToolsPG18dropdb dropdb — remove a PostgreSQL database Synopsis dropdb [connection-option...] [option...] dbnamedropdb dropdbManual ChaptersPG18dropdb dropdb — remove a PostgreSQL database Synopsis dropdb [connection-option...] [option...] dbnamedropdb dropdb --echoCommand-line ToolsPG18-e--echo Echo the commands that dropdb generates and sends to the server.dropdb › Options dropdb --forceCommand-line ToolsPG18-f--force Attempt to terminate all existing connections to the target database before dropping it. See DROP DATABASE for more information on this option.dropdb › Options dropdb --helpCommand-line ToolsPG18-?--help Show help about dropdb command line arguments, and exit.dropdb › Options dropdb --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.dropdb › Options dropdb --if-existsCommand-line ToolsPG18--if-exists Do not throw an error if the database does not exist. A notice is issued in this case.dropdb › Options dropdb --interactiveCommand-line ToolsPG18-i--interactive Issues a verification prompt before doing anything destructive.dropdb › Options dropdb --maintenance-db=dbnameCommand-line ToolsPG18--maintenance-db=dbname Specifies the name of the database to connect to in order to drop the target database. If not specified, the postgres database will be used; if that does not exist (o…dropdb › Options dropdb --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…dropdb › Options dropdb --passwordCommand-line ToolsPG18-W--password Force dropdb to prompt for a password before connecting to a database. This option is never essential, since dropdb will automatically prompt for a password if the server demand…dropdb › Options dropdb --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.dropdb › Options dropdb --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.dropdb › Options