Database.PostgreSQL.ORM.SqlType

Documentation

class (ToField a, FromField a) => SqlType a where

The class of Haskell types that can be converted to and from a particular SQL type. For most instances, you only need to define sqlBaseType.

Methods

sqlBaseType :: a -> ByteString

The name of the SQL type corresponding to Haskell type a, when a value of a can be null. This is the SQL type to and from which a Maybe a will be converted (where Nothing corresponds to the SQL value null).

sqlType :: a -> ByteString

The name of the SQL type corresponding to Haskell type a, when a is not wrapped in Maybe and hence cannot be null. If sqlType is unspecified, the default is to append "NOT NULL" to sqlBaseType.

Instances

SqlType Bool

SqlType Double

SqlType Float

SqlType Int16

SqlType Int32

SqlType Int64

SqlType String

SqlType ByteString

SqlType ByteString

SqlType Text

SqlType UTCTime

SqlType Text

SqlType Oid

SqlType LocalTimestamp

SqlType UTCTimestamp

SqlType ZonedTimestamp

SqlType Date

SqlType LocalTime

SqlType ZonedTime

SqlType TimeOfDay

SqlType Day

SqlType DBKey

SqlType a => SqlType (Maybe a)

SqlType (Binary ByteString)

SqlType (Binary ByteString)

(Typeable a, SqlType a) => SqlType (Vector a)

Model a => SqlType (DBRefUnique a)

Model a => SqlType (DBRef a)

getTypeOid :: Connection -> ByteString -> IO Oid

Retreive the Oid corresponding to a type. You can subsequently use the Oid to call getTypeInfo for more information on the type.