CLUSTER – cluster a table according to an index Synopsis CLUSTER [VERBOSE] tablename [ USING indexname ] CLUSTER [VERBOSE] Description CLUSTER instructs PostgreSQL to cluster the table specified by tablename based on the index specified by indexname. The index must already have been defined on tablename. When a table is clustered, it is physically reordered…
CLOSE – close a cursor Synopsis CLOSE { name | ALL } Description CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor should be closed when it is no longer needed. Every non-holdable open cursor is implicitly closed when a transaction…
CHECKPOINT – force a transaction log checkpoint Synopsis CHECKPOINT Description Write-Ahead Logging (WAL) puts a checkpoint in the transaction log every so often. (To adjust the automatic checkpoint interval, see the run-time configuration options checkpoint_segments and checkpoint_timeout.) The CHECKPOINT command forces an immediate checkpoint when the command is issued, without waiting for a scheduled checkpoint….
BEGIN – start a transaction block Synopsis BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, …] ] where transaction_mode is one of: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED } READ WRITE | READ ONLY Description BEGIN initiates a transaction block, that is, all statements after a BEGIN…
ANALYZE – collect statistics about a database Synopsis ANALYZE [ VERBOSE ] [ table [ ( column [, …] ) ] ] Description ANALYZE collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these statistics to help determine the most…
ALTER VIEW – change the definition of a view Synopsis ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT ALTER VIEW name OWNER TO new_owner ALTER VIEW name RENAME TO new_name ALTER VIEW name SET SCHEMA new_schema Description ALTER VIEW changes various auxiliary…
ALTER USER MAPPING – change the definition of a user mapping Synopsis ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC } SERVER servername OPTIONS ( [ ADD | SET | DROP ] option [‘value’] [, … ] ) Description ALTER USER MAPPING changes the definition of a user mapping. The owner…
ALTER USER – change a database role Synopsis ALTER USER name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT connlimit | [ ENCRYPTED |…
ALTER TYPE – change the definition of a type Synopsis ALTER TYPE name RENAME TO new_name ALTER TYPE name OWNER TO new_owner ALTER TYPE name SET SCHEMA new_schema Description ALTER TYPE changes the definition of an existing type. You must own the type to use ALTER TYPE. To change the schema of a type, you…
ALTER TRIGGER – change the definition of a trigger Synopsis ALTER TRIGGER name ON table RENAME TO newname Description ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing the trigger definition. You must own the table on which the trigger acts to be…
ALTER TEXT SEARCH TEMPLATE – change the definition of a text search template Synopsis ALTER TEXT SEARCH TEMPLATE name RENAME TO newname Description ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. Currently, the only supported functionality is to change the template’s name. You must be a superuser to use ALTER TEXT…
ALTER TEXT SEARCH PARSER – change the definition of a text search parser Synopsis ALTER TEXT SEARCH PARSER name RENAME TO newname Description ALTER TEXT SEARCH PARSER changes the definition of a text search parser. Currently, the only supported functionality is to change the parser’s name. You must be a superuser to use ALTER TEXT…
ALTER TEXT SEARCH DICTIONARY – change the definition of a text search dictionary Synopsis ALTER TEXT SEARCH DICTIONARY name ( option [ = value ] [, … ] ) ALTER TEXT SEARCH DICTIONARY name RENAME TO newname ALTER TEXT SEARCH DICTIONARY name OWNER TO newowner Description ALTER TEXT SEARCH DICTIONARY changes the definition of a…
ALTER TEXT SEARCH CONFIGURATION – change the definition of a text search configuration Synopsis ALTER TEXT SEARCH CONFIGURATION name ADD MAPPING FOR token_type [, … ] WITH dictionary_name [, … ] ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING FOR token_type [, … ] WITH dictionary_name [, … ] ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING…
ALTER TABLESPACE – change the definition of a tablespace Synopsis ALTER TABLESPACE name RENAME TO newname ALTER TABLESPACE name OWNER TO newowner Description ALTER TABLESPACE changes the definition of a tablespace. You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the…
ALTER TABLE – change the definition of a table Synopsis ALTER TABLE [ ONLY ] name [ * ] action [, … ] ALTER TABLE [ ONLY ] name [ * ] RENAME [ COLUMN ] column TO new_column ALTER TABLE name RENAME TO new_name ALTER TABLE name SET SCHEMA new_schema where action is one…
ALTER SERVER – change the definition of a foreign server Synopsis ALTER SERVER servername [ VERSION ‘newversion’ ] [ OPTIONS ( [ ADD | SET | DROP ] option [‘value’] [, … ] ) ] ALTER SERVER servername OWNER TO new_owner Description ALTER SERVER changes the definition of a foreign server. The first form changes…
ALTER SEQUENCE – change the definition of a sequence generator Synopsis ALTER SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ RESTART [ [ WITH ] restart ] ] [ CACHE cache ]…
ALTER SCHEMA – change the definition of a schema Synopsis ALTER SCHEMA name RENAME TO newname ALTER SCHEMA name OWNER TO newowner Description ALTER SCHEMA changes the definition of a schema. You must own the schema to use ALTER SCHEMA. To rename a schema you must also have the CREATE privilege for the database. To…
ALTER ROLE – change a database role Synopsis ALTER ROLE name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT connlimit | [ ENCRYPTED |…