Postgres support (indexes)

[nene]

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