45 lines
2.1 KiB
Text
45 lines
2.1 KiB
Text
|
-- options of some commands
|
||
|
|
|
||
|
|
WITH, WITH ( .. ), (),
|
||
|
|
-- alter/create role
|
||
|
|
SUPERUSER, NOSUPERUSER, CREATEDB, NOCREATEDB, CREATEROLE, NOCREATEROLE, INHERIT, NOINHERIT,
|
||
|
|
LOGIN, NOLOGIN, REPLICATION, NOREPLICATION, BYPASSRLS, NOBYPASSRLS, CONNECTION LIMIT 100,
|
||
|
|
ENCRYPTED PASSWORD, UNENCRYPTED PASSWORD, VALID UNTIL '2020-01-01',
|
||
|
|
IN ROLE, IN GROUP, ROLE, ADMIN, USER, SYSID;
|
||
|
|
-- copy
|
||
|
|
FORMAT, OIDS, FREEZE, DELIMITER, NULL '..', HEADER, QUOTE, ESCAPE, FORCE_QUOTE,
|
||
|
|
FORCE_NOT_NULL, FORCE_NULL, ENCODING;
|
||
|
|
-- create aggregate
|
||
|
|
BASETYPE=, SFUNC=, STYPE=, SSPACE=, FINALFUNC=, FINALFUNC_EXTRA=,
|
||
|
|
FINALFUNC_MODIFY=, COMBINEFUNC=, SERIALFUNC=, DESERIALFUNC=,
|
||
|
|
INITCOND=, MSFUNC=, MINVFUNC=, MSTYPE=, MSSPACE=, MFINALFUNC=, MFINALFUNC_EXTRA=,
|
||
|
|
MFINALFUNC_MODIFY=, MINITCOND=, SORTOP=, PARALLEL=;
|
||
|
|
-- create collation
|
||
|
|
LOCALE=, LC_COLLATE=, LC_CTYPE=, PROVIDER=, VERSION=;
|
||
|
|
-- create dataase
|
||
|
|
OWNER=, TEMPLATE=, ENCODING=, LC_COLLATE=, LC_CTYPE=, TABLESPACE=, ALLOW_CONNECTIONS=,
|
||
|
|
CONNECTION LIMIT=, IS_TEMPLATE=;
|
||
|
|
-- create extension
|
||
|
|
SCHEMA, VERSION, FROM, CASCADE;
|
||
|
|
-- create operator
|
||
|
|
PROCEDURE=, LEFTARG=, RIGHTARG=, COMMUTATOR=, NEGATOR=, RESTRICT=, JOIN=, HASHES=, MERGES=
|
||
|
|
-- create text search configuration
|
||
|
|
PARSER=, COPY=;
|
||
|
|
-- create text search dictionary
|
||
|
|
TEMPLATE=;
|
||
|
|
-- create text search parser
|
||
|
|
START=, GETTOKEN=, END=, LEXTYPES=, HEADLINE=;
|
||
|
|
-- create text search template
|
||
|
|
INIT=, LEXIZE=;
|
||
|
|
-- create type
|
||
|
|
SUBTYPE=, SUBTYPE_OPCLASS=, COLLATION=, CANONICAL=, SUBTYPE_DIFF=,
|
||
|
|
INPUT=, OUTPUT=, RECEIVE=, SEND=, TYPMOD_IN=, TYPMOD_OUT=, ANALYZE=, INTERNALLENGTH=, PASSEDBYVALUE=,
|
||
|
|
ALIGNMENT=, STORAGE=, LIKE=, CATEGORY=, PREFERRED=, DEFAULT=, ELEMENT=, DELIMITER=, COLLATABLE=;
|
||
|
|
-- analyze/explain/vacuum
|
||
|
|
ANALYZE, VERBOSE, COSTS, BUFFERS, TIMING, SUMMARY, FORMAT TEXT, FORMAT XML, FORMAT JSON,
|
||
|
|
FORMAT YAML, FREEZE, FULL, DISABLE_PAGE_SKIPPING;
|
||
|
|
|
||
|
|
-- table like options
|
||
|
|
|
||
|
|
TABLE t1(LIKE t1 INCLUDING COMMENTS INCLUDING CONSTRAINTS EXCLUDING DEFAULTS INCLUDING IDENTITY INCLUDING INDEXES INCLUDING STATISTICS INCLUDING STORAGE EXCLUDING ALL);
|