Linux Manuals session 7

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 [, …] )…

CREATE OPERATOR – define a new operator Synopsis CREATE OPERATOR name ( PROCEDURE = funcname [, LEFTARG = lefttype ] [, RIGHTARG = righttype ] [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] [, JOIN = join_proc ] [, HASHES ] [, MERGES ] ) Description CREATE OPERATOR…

CREATE LANGUAGE – define a new procedural language Synopsis CREATE [ PROCEDURAL ] LANGUAGE name CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ VALIDATOR valfunction ] Description Using CREATE LANGUAGE, a PostgreSQL user can register a new procedural language with a PostgreSQL database. Subsequently, functions and trigger procedures can be defined…

CREATE INDEX – define a new index Synopsis CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] name ON table [ USING method ] ( { column | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, …] ) [ WITH ( storage_parameter =…

CREATE GROUP – define a new database role Synopsis CREATE GROUP name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | [ ENCRYPTED | UNENCRYPTED ] PASSWORD…

CREATE FUNCTION – define a new function Synopsis CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } defexpr ] [, …] ] ) [ RETURNS rettype | RETURNS TABLE ( colname coltype [, …] ) ] { LANGUAGE langname | WINDOW |…

CREATE_FOREIGN_TABLE – define a new foreign table Synopsis CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option ‘value’ [, … ] ) ] [ NULL | NOT NULL ] } [, … ] ] ) SERVER server_name [ OPTIONS ( option ‘value’ [, … ] )…

CREATE FOREIGN DATA WRAPPER – define a new foreign-data wrapper Synopsis CREATE FOREIGN DATA WRAPPER name [ VALIDATOR valfunction | NO VALIDATOR ] [ OPTIONS ( option ‘value’ [, … ] ) ] Description CREATE FOREIGN DATA WRAPPER creates a new foreign-data wrapper. The user who defines a foreign-data wrapper becomes its owner. The foreign-data…

CREATE_EXTENSION – install an extension Synopsis CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ FROM old_version ] Description CREATE EXTENSION loads a new extension into the current database. There must not be an extension of the same name already loaded. Loading an extension…

CREATE DOMAIN – define a new domain Synopsis CREATE DOMAIN name [ AS ] data_type [ DEFAULT expression ] [ constraint [ … ] ] where constraint is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK (expression) } Description CREATE DOMAIN creates a new domain. A domain is essentially a data type…