Section 7: overview, conventions, and miscellany
DROP DOMAIN – remove a domain Synopsis DROP DOMAIN [ IF EXISTS ] name [, …] [ CASCADE | RESTRICT ] Description DROP DOMAIN removes a domain. Only the owner of a domain can remove it. Parameters IF EXISTS Do not throw an error if the domain does not exist. A notice is issued in…
DROP DATABASE – remove a database Synopsis DROP DATABASE [ IF EXISTS ] name Description DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are…
DROP CONVERSION – remove a conversion Synopsis DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion. Parameters IF EXISTS Do not throw an error if the conversion does not exist. A notice…
DROP_COLLATION – remove a collation Synopsis DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] Description DROP COLLATION removes a previously defined collation. To be able to drop a collation, you must own the collation. Parameters IF EXISTS Do not throw an error if the collation does not exist. A notice is…
DROP CAST – remove a cast Synopsis DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ] Description DROP CAST removes a previously defined cast. To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to…
DROP AGGREGATE – remove an aggregate function Synopsis DROP AGGREGATE [ IF EXISTS ] name ( type [ , … ] ) [ CASCADE | RESTRICT ] Description DROP AGGREGATE removes an existing aggregate function. To execute this command the current user must be the owner of the aggregate function. Parameters IF EXISTS Do not…
DO – execute an anonymous code block Synopsis DO [ LANGUAGE lang_name ] code Description DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language. The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed…
DISCARD – discard session state Synopsis DISCARD { ALL | PLANS | TEMPORARY | TEMP } Description DISCARD releases internal resources associated with a database session. These resources are normally released at the end of the session. DISCARD TEMP drops all temporary tables created in the current session. DISCARD PLANS releases all internally cached query…
DELETE – delete rows of a table Synopsis DELETE FROM [ ONLY ] table [ [ AS ] alias ] [ USING usinglist ] [ WHERE condition | WHERE CURRENT OF cursor_name ] [ RETURNING * | output_expression [ [ AS ] output_name ] [, …] ] Description DELETE deletes rows that satisfy the WHERE…
DECLARE – define a cursor Synopsis DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query Description DECLARE allows a user to create cursors, which can be used to retrieve a small number of rows at a time out of…
DEALLOCATE – deallocate a prepared statement Synopsis DEALLOCATE [ PREPARE ] { name | ALL } Description DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends. For more information on prepared statements, see PREPARE [prepare(7)]. Parameters PREPARE This…
XConsortium – X Consortium information Synopsis Releases 6.0 through 6.3 of X Version 11 were brought to you by the X Consortium, Inc. Description The X Consortium was an independent, not-for-profit Delaware membership corporation. It was formed in 1993 as the successor to the MIT X Consortium. The purpose of the X Consortium was to…
CREATE VIEW – define a new view Synopsis CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, …] ) ] AS query Description CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced…
CREATE USER MAPPING – define a new mapping of a user to a foreign server Synopsis CREATE USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC } SERVER servername [ OPTIONS ( option ‘value’ [ , … ] ) ] Description CREATE USER MAPPING defines a mapping of a user to a foreign…
CREATE USER – define a new database role Synopsis CREATE USER name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT connlimit | [ ENCRYPTED…
CREATE TYPE – define a new data type Synopsis CREATE TYPE name AS ( attribute_name data_type [, … ] ) CREATE TYPE name AS ENUM ( ‘label’ [, … ] ) CREATE TYPE name ( INPUT = input_function, OUTPUT = output_function [ , RECEIVE = receive_function ] [ , SEND = send_function ] [ ,…
CREATE TRIGGER – define a new trigger Synopsis CREATE TRIGGER name { BEFORE | AFTER } { event [ OR … ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE funcname ( arguments ) Description CREATE TRIGGER creates a new trigger. The trigger will be associated with…
CREATE TEXT SEARCH TEMPLATE – define a new text search template Synopsis CREATE TEXT SEARCH TEMPLATE name ( [ INIT = init_function , ] LEXIZE = lexize_function ) Description CREATE TEXT SEARCH TEMPLATE creates a new text search template. Text search templates define the functions that implement text search dictionaries. A template is not useful…
CREATE TEXT SEARCH PARSER – define a new text search parser Synopsis CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = end_function , LEXTYPES = lextypes_function [, HEADLINE = headline_function ] ) Description CREATE TEXT SEARCH PARSER creates a new text search parser. A text search parser defines…
CREATE TEXT SEARCH DICTIONARY – define a new text search dictionary Synopsis CREATE TEXT SEARCH DICTIONARY name ( TEMPLATE = template [, option = value [, … ]] ) Description CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search dictionary specifies a way of recognizing interesting or uninteresting words for searching….