Search PostgreSQL documentation

DROP POLICYManual ChaptersPG18DROP POLICY DROP POLICY — remove a row-level security policy from a table Synopsis DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP POLICY DROP PROCEDUREManual ChaptersPG18DROP PROCEDURE DROP PROCEDURE — remove a procedure Synopsis DROP PROCEDURE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP PROCEDURE DROP PUBLICATIONManual ChaptersPG18DROP PUBLICATION DROP PUBLICATION — remove a publication Synopsis DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP PUBLICATION DROP ROLEManual ChaptersPG18DROP ROLE DROP ROLE — remove a database role Synopsis DROP ROLE [ IF EXISTS ] name [, ...]DROP ROLE DROP ROUTINEManual ChaptersPG18DROP ROUTINE DROP ROUTINE — remove a routine Synopsis DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP ROUTINE DROP RULEManual ChaptersPG18DROP RULE DROP RULE — remove a rewrite rule Synopsis DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP RULE DROP SCHEMAManual ChaptersPG18DROP SCHEMA DROP SCHEMA — remove a schema Synopsis DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SCHEMA DROP SEQUENCEManual ChaptersPG18DROP SEQUENCE DROP SEQUENCE — remove a sequence Synopsis DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SEQUENCE DROP SERVERManual ChaptersPG18DROP SERVER DROP SERVER — remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP SERVER DROP STATISTICSManual ChaptersPG18DROP STATISTICS DROP STATISTICS — remove extended statistics Synopsis DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP STATISTICS DROP SUBSCRIPTIONManual ChaptersPG18DROP SUBSCRIPTION DROP SUBSCRIPTION — remove a subscription Synopsis DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP SUBSCRIPTION DROP TABLEManual ChaptersPG18DROP TABLE DROP TABLE — remove a table Synopsis DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP TABLE DROP TABLESPACEManual ChaptersPG18DROP TABLESPACE DROP TABLESPACE — remove a tablespace Synopsis DROP TABLESPACE [ IF EXISTS ] nameDROP TABLESPACE 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 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 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 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 TRANSFORMManual ChaptersPG18DROP TRANSFORM DROP TRANSFORM — remove a transform Synopsis DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]DROP TRANSFORM DROP TRIGGERManual ChaptersPG18DROP TRIGGER DROP TRIGGER — remove a trigger Synopsis DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]DROP TRIGGER DROP TYPEManual ChaptersPG18DROP TYPE DROP TYPE — remove a data type Synopsis DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP TYPE DROP USERManual ChaptersPG18DROP USER DROP USER — remove a database role Synopsis DROP USER [ IF EXISTS ] name [, ...]DROP USER 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 VIEWManual ChaptersPG18DROP VIEW DROP VIEW — remove a view Synopsis DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP VIEW dropdbManual ChaptersPG18dropdb dropdb — remove a PostgreSQL database Synopsis dropdb [connection-option...] [option...] dbnamedropdb Dropping RolesManual ChaptersPG1821.4. Dropping Roles Because roles can own database objects and can hold privileges to access other objects, dropping a role is often not just a matter of a quick DROP ROLE. Any objects owne…Dropping Roles dropuserManual ChaptersPG18dropuser dropuser — remove a PostgreSQL user account Synopsis dropuser [connection-option...] [option...] [username]dropuser Dynamic Domain TransitionsManual ChaptersPG18F.40.5.5. Dynamic Domain Transitions It is possible to use SELinux's dynamic domain transition feature to switch the security label of the client process, the client domain, to a new context…Dynamic Domain Transitions Dynamic LoadingManual ChaptersPG1836.10.1. Dynamic Loading The first time a user-defined function in a particular loadable object file is called in a session, the dynamic loader loads that object file into memory so that the…Dynamic Loading Dynamic SQLManual ChaptersPG1834.5. Dynamic SQL In many cases, the particular SQL statements that an application has to execute are known at the time the application is written. In some cases, however, the SQL statements…Dynamic SQL Dynamic TracingManual ChaptersPG1827.5. Dynamic Tracing PostgreSQL provides facilities to support dynamic tracing of the database server. This allows an external utility to be called at specific points in the code and thereb…Dynamic Tracing earthdistance — calculate great-circle distancesManual ChaptersPG18F.14. earthdistance — calculate great-circle distances The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one d…earthdistance — calculate great-circle distances ecpgManual ChaptersPG18ecpg ecpg — embedded SQL C preprocessor Synopsis ecpg [option...] file...ecpg ECPG — Embedded SQL in CManual ChaptersPG18Chapter 34. ECPG — Embedded SQL in C This chapter describes the embedded SQL package for PostgreSQL. It was written by Linus Tolke (<linus@epact.se>) and Michael Meskes (<meskes@postgresql.o…ECPG — Embedded SQL in C Editing the PO FilesManual ChaptersPG1856.1.4. Editing the PO Files The PO files can be edited with a regular text editor. There are also several specialized editors for PO files which can help the process with translation-specif…Editing the PO Files element_typesManual ChaptersPG1835.24. element_types The view element_types contains the data type descriptors of the elements of arrays. When a table column, composite-type attribute, domain, function parameter, or functi…element_types EmacsManual ChaptersPG18J.5.1. Emacs nXML Mode, which ships with Emacs, is the most common mode for editing XML documents with Emacs. It will allow you to use Emacs to insert tags and check markup consistency, and …Emacs Embedded SQL CommandsManual ChaptersPG1834.14. Embedded SQL Commands This section describes all SQL commands that are specific to embedded SQL. Also refer to the SQL commands listed in SQL Commands, which can also be used in embed…Embedded SQL Commands Empty SELECT ListsManual ChaptersPG18Empty SELECT Lists The list of output expressions after SELECT can be empty, producing a zero-column result table. This is not valid syntax according to the SQL standard. PostgreSQL allows i…Empty SELECT Lists enabled_rolesManual ChaptersPG1835.25. enabled_roles The view enabled_roles identifies the currently “enabled roles”. The enabled roles are recursively defined as the current user together with all roles that have been gra…enabled_roles Encoding HandlingManual ChaptersPG188.13.2. Encoding Handling Care must be taken when dealing with multiple character encodings on the client, server, and in the XML data passed through them. When using the text mode to pass q…Encoding Handling