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….
CREATE TEXT SEARCH CONFIGURATION – define a new text search configuration Synopsis CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config ) Description CREATE TEXT SEARCH CONFIGURATION creates a new text search configuration. A text search configuration specifies a text search parser that can divide a string into tokens, plus dictionaries…
CREATE TABLE AS – define a new table from the results of a query Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, …] ) ] [ WITH ( storage_parameter [= value] [, … ] ) | WITH OIDS | WITHOUT OIDS ] [ ON…
CREATE TABLESPACE – define a new tablespace Synopsis CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION ‘directory’ Description CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in the database cluster. A tablespace allows superusers to define an alternative location on the file system…
CREATE TABLE – define a new table Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( [ { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ … ] ] | table_constraint | LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES…
CREATE SERVER – define a new foreign server Synopsis CREATE SERVER servername [ TYPE ‘servertype’ ] [ VERSION ‘serverversion’ ] FOREIGN DATA WRAPPER fdwname [ OPTIONS ( option ‘value’ [, … ] ) ] Description CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner. A foreign server typically…
CREATE SEQUENCE – define a new sequence generator Synopsis CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]…
CREATE SCHEMA – define a new schema Synopsis CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ … ] ] CREATE SCHEMA AUTHORIZATION username [ schema_element [ … ] ] Description CREATE SCHEMA enters a new schema into the current database. The schema name must be distinct from the name of any existing schema…
CREATE RULE – define a new rewrite rule Synopsis CREATE [ OR REPLACE ] RULE name AS ON event TO table [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command … ) } Description CREATE RULE defines a new rule applying to a specified table…
CREATE ROLE – define a new database role Synopsis CREATE ROLE name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT connlimit | [ ENCRYPTED…
CREATE OPERATOR FAMILY – define a new operator family Synopsis CREATE OPERATOR FAMILY name USING index_method Description CREATE OPERATOR FAMILY creates a new operator family. An operator family defines a collection of related operator classes, and perhaps some additional operators and support functions that are compatible with these operator classes but not essential for the…
CREATE OPERATOR CLASS – define a new operator class Synopsis CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY family_name ] AS { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] | FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, …] )…