Postgres support (indexes) #58
Description
- CREATE INDEX
-
CREATE UNIQUE INDEX -
CONCURRENTLY -
IF NOT EXISTS - no name
-
ON [ONLY] table_name -
USING method - columns:
-
column_name | ( expression ) -
COLLATE collation -
opclass -
( opclass_parameter = value [, ... ] ) -
ASC | DESC -
NULLS { FIRST | LAST }
-
-
INCLUDE ( column_name [, ...] ) -
NULLS [ NOT ] DISTINCT -
WITH ( storage_parameter [= value] [, ... ] ) -
TABLESPACE tablespace_name -
WHERE predicate
-
- DROP INDEX
-
CONCURRENTLY -
IF EXISTS - multiple indexes
-
CASCADE | RESTRICT
-
- REINDEX
-
( option [, ...] )whereoptionis one of:-
CONCURRENTLY [ boolean ] -
TABLESPACE new_tablespace -
VERBOSE [ boolean ]
-
-
INDEX | TABLE | SCHEMA -
DATABASE | SYSTEM -
CONCURRENTLY - optional
name
-
- ALTER INDEX
-
IF EXISTS -
RENAME TO new_name -
SET TABLESPACE tablespace_name -
ATTACH PARTITION index_name -
[ NO ] DEPENDS ON EXTENSION extension_name -
SET ( storage_parameter [= value] [, ... ] ) -
RESET ( storage_parameter [, ... ] ) -
ALTER [ COLUMN ] column_number SET STATISTICS integer -
ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ] SET TABLESPACE new_tablespace [ NOWAIT ]
-