Database.HDBI.PostgreSQL

HDBI driver interface for PostgreSQL 8.x and above

Written by John Goerzen, [e-mail]

Documentation

data PostgreConnection

Constructors

PostgreConnection

Fields

postNative :: MVar (Maybe Connection)

LibPQ connection if established

postStatements :: ChildList PostgreStatement

List of weak refs to statements to finalize on disconnect

postConnString :: Text

Original connection string

Instances

Typeable PostgreConnection

Connection PostgreConnection

data PostgreStatement

Constructors

PostgreStatement

Fields

stQuery :: Query

Initial query

stConnection :: PostgreConnection

Connection this statement working with

stState :: MVar PGStatementState

State of statement

Instances

Typeable PostgreStatement

Statement PostgreStatement

data PGStatementState

Constructors

STNew

Newly created or reseted statement

STExecuted

Just executed statement

Fields

pgstResult :: !Result

The result to fetch data from

STFetching

Fetching rows is in progress

Fields

pgstResult :: !Result

The result to fetch data from

pgstColumns :: !Column

Columns count

pgstFormats :: ![Format]

pgstTypes :: ![Oid]

pgstTuples :: !Row

Tuples in result

pgstCurrent :: !Row

Row number waiting to fetch

STFinished

Statement is finished, can still be reseted

connectPostgreSQL

Arguments

:: Text

Connection string according to the documentation

-> IO PostgreConnection

Establish new PostgreSQL connection

pgAffectedRows :: PostgreStatement -> IO Integer

Get the count of rows affected by UPDATE, DELETE or INSERT query