hpqtypes-extras-1.9.0.1: Extra utilities for hpqtypes library

Safe HaskellNone
LanguageHaskell2010

Database.PostgreSQL.PQTypes.Model.Index

Synopsis

Documentation

data TableIndex Source #

Constructors

TableIndex 

Fields

indexOnColumnWithMethod :: RawSQL () -> IndexMethod -> TableIndex Source #

Create an index on the given column with the specified method. No checks are made that the method is appropriate for the type of the column.

indexOnColumnsWithMethod :: [RawSQL ()] -> IndexMethod -> TableIndex Source #

Create an index on the given columns with the specified method. No checks are made that the method is appropriate for the type of the column; cf. the PostgreSQL manual.

sqlCreateIndex :: RawSQL () -> TableIndex -> RawSQL () Source #

Deprecated: Use sqlCreateIndexSequentially instead

Deprecated version of sqlCreateIndexSequentially.

sqlCreateIndexSequentially :: RawSQL () -> TableIndex -> RawSQL () Source #

Create index sequentially. Warning: if the affected table is large, this will prevent the table from being modified during the creation. If this is not acceptable, use sqlCreateIndexConcurrently. See https://www.postgresql.org/docs/current/sql-createindex.html for more information.

sqlCreateIndexConcurrently :: RawSQL () -> TableIndex -> RawSQL () Source #

Create index concurrently.