-- 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);