postgresql-simple-0.7.0.1: Mid-Level PostgreSQL client library

Copyright | (c) 2011-2012 Leon P Smith
License | BSD3
Maintainer | Leon P Smith <leon@melding-monads.com>
Stability | experimental
Safe Haskell | None
Language | Haskell2010

Database.PostgreSQL.Simple.TypeInfo.Static

Description

This module contains portions of the `pg_type` table that are relevant to postgresql-simple and are believed to not change between PostgreSQL versions.

Synopsis

- data TypeInfo
  - = Basic {
    - typoid :: !Oid
    - typcategory :: !Char
    - typdelim :: !Char
    - typname :: !ByteString
    }
  - | Array {
    - typoid :: !Oid
    - typcategory :: !Char
    - typdelim :: !Char
    - typname :: !ByteString
    - typelem :: !TypeInfo
    }
  - | Range {
    - typoid :: !Oid
    - typcategory :: !Char
    - typdelim :: !Char
    - typname :: !ByteString
    - rngsubtype :: !TypeInfo
    }
  - | Composite {
    - typoid :: !Oid
    - typcategory :: !Char
    - typdelim :: !Char
    - typname :: !ByteString
    - typrelid :: !Oid
    - attributes :: !(Vector Attribute)
    }
- staticTypeInfo :: Oid -> Maybe TypeInfo
- bool :: TypeInfo
- boolOid :: Oid
- bytea :: TypeInfo
- byteaOid :: Oid
- char :: TypeInfo
- charOid :: Oid
- name :: TypeInfo
- nameOid :: Oid
- int8 :: TypeInfo
- int8Oid :: Oid
- int2 :: TypeInfo
- int2Oid :: Oid
- int4 :: TypeInfo
- int4Oid :: Oid
- regproc :: TypeInfo
- regprocOid :: Oid
- text :: TypeInfo
- textOid :: Oid
- oid :: TypeInfo
- oidOid :: Oid
- tid :: TypeInfo
- tidOid :: Oid
- xid :: TypeInfo
- xidOid :: Oid
- cid :: TypeInfo
- cidOid :: Oid
- xml :: TypeInfo
- xmlOid :: Oid
- point :: TypeInfo
- pointOid :: Oid
- lseg :: TypeInfo
- lsegOid :: Oid
- path :: TypeInfo
- pathOid :: Oid
- box :: TypeInfo
- boxOid :: Oid
- polygon :: TypeInfo
- polygonOid :: Oid
- line :: TypeInfo
- lineOid :: Oid
- cidr :: TypeInfo
- cidrOid :: Oid
- float4 :: TypeInfo
- float4Oid :: Oid
- float8 :: TypeInfo
- float8Oid :: Oid
- unknown :: TypeInfo
- unknownOid :: Oid
- circle :: TypeInfo
- circleOid :: Oid
- money :: TypeInfo
- moneyOid :: Oid
- macaddr :: TypeInfo
- macaddrOid :: Oid
- inet :: TypeInfo
- inetOid :: Oid
- bpchar :: TypeInfo
- bpcharOid :: Oid
- varchar :: TypeInfo
- varcharOid :: Oid
- date :: TypeInfo
- dateOid :: Oid
- time :: TypeInfo
- timeOid :: Oid
- timestamp :: TypeInfo
- timestampOid :: Oid
- timestamptz :: TypeInfo
- timestamptzOid :: Oid
- interval :: TypeInfo
- intervalOid :: Oid
- timetz :: TypeInfo
- timetzOid :: Oid
- bit :: TypeInfo
- bitOid :: Oid
- varbit :: TypeInfo
- varbitOid :: Oid
- numeric :: TypeInfo
- numericOid :: Oid
- refcursor :: TypeInfo
- refcursorOid :: Oid
- record :: TypeInfo
- recordOid :: Oid
- void :: TypeInfo
- voidOid :: Oid
- array_record :: TypeInfo
- array_recordOid :: Oid
- regprocedure :: TypeInfo
- regprocedureOid :: Oid
- regoper :: TypeInfo
- regoperOid :: Oid
- regoperator :: TypeInfo
- regoperatorOid :: Oid
- regclass :: TypeInfo
- regclassOid :: Oid
- regtype :: TypeInfo
- regtypeOid :: Oid
- uuid :: TypeInfo
- uuidOid :: Oid
- json :: TypeInfo
- jsonOid :: Oid
- jsonb :: TypeInfo
- jsonbOid :: Oid
- int2vector :: TypeInfo
- int2vectorOid :: Oid
- oidvector :: TypeInfo
- oidvectorOid :: Oid
- array_xml :: TypeInfo
- array_xmlOid :: Oid
- array_json :: TypeInfo
- array_jsonOid :: Oid
- array_line :: TypeInfo
- array_lineOid :: Oid
- array_cidr :: TypeInfo
- array_cidrOid :: Oid
- array_circle :: TypeInfo
- array_circleOid :: Oid
- array_money :: TypeInfo
- array_moneyOid :: Oid
- array_bool :: TypeInfo
- array_boolOid :: Oid
- array_bytea :: TypeInfo
- array_byteaOid :: Oid
- array_char :: TypeInfo
- array_charOid :: Oid
- array_name :: TypeInfo
- array_nameOid :: Oid
- array_int2 :: TypeInfo
- array_int2Oid :: Oid
- array_int2vector :: TypeInfo
- array_int2vectorOid :: Oid
- array_int4 :: TypeInfo
- array_int4Oid :: Oid
- array_regproc :: TypeInfo
- array_regprocOid :: Oid
- array_text :: TypeInfo
- array_textOid :: Oid
- array_tid :: TypeInfo
- array_tidOid :: Oid
- array_xid :: TypeInfo
- array_xidOid :: Oid
- array_cid :: TypeInfo
- array_cidOid :: Oid
- array_oidvector :: TypeInfo
- array_oidvectorOid :: Oid
- array_bpchar :: TypeInfo
- array_bpcharOid :: Oid
- array_varchar :: TypeInfo
- array_varcharOid :: Oid
- array_int8 :: TypeInfo
- array_int8Oid :: Oid
- array_point :: TypeInfo
- array_pointOid :: Oid
- array_lseg :: TypeInfo
- array_lsegOid :: Oid
- array_path :: TypeInfo
- array_pathOid :: Oid
- array_box :: TypeInfo
- array_boxOid :: Oid
- array_float4 :: TypeInfo
- array_float4Oid :: Oid
- array_float8 :: TypeInfo
- array_float8Oid :: Oid
- array_polygon :: TypeInfo
- array_polygonOid :: Oid
- array_oid :: TypeInfo
- array_oidOid :: Oid
- array_macaddr :: TypeInfo
- array_macaddrOid :: Oid
- array_inet :: TypeInfo
- array_inetOid :: Oid
- array_timestamp :: TypeInfo
- array_timestampOid :: Oid
- array_date :: TypeInfo
- array_dateOid :: Oid
- array_time :: TypeInfo
- array_timeOid :: Oid
- array_timestamptz :: TypeInfo
- array_timestamptzOid :: Oid
- array_interval :: TypeInfo
- array_intervalOid :: Oid
- array_numeric :: TypeInfo
- array_numericOid :: Oid
- array_timetz :: TypeInfo
- array_timetzOid :: Oid
- array_bit :: TypeInfo
- array_bitOid :: Oid
- array_varbit :: TypeInfo
- array_varbitOid :: Oid
- array_refcursor :: TypeInfo
- array_refcursorOid :: Oid
- array_regprocedure :: TypeInfo
- array_regprocedureOid :: Oid
- array_regoper :: TypeInfo
- array_regoperOid :: Oid
- array_regoperator :: TypeInfo
- array_regoperatorOid :: Oid
- array_regclass :: TypeInfo
- array_regclassOid :: Oid
- array_regtype :: TypeInfo
- array_regtypeOid :: Oid
- array_uuid :: TypeInfo
- array_uuidOid :: Oid
- array_jsonb :: TypeInfo
- array_jsonbOid :: Oid
- int4range :: TypeInfo
- int4rangeOid :: Oid
- _int4range :: TypeInfo
- _int4rangeOid :: Oid
- numrange :: TypeInfo
- numrangeOid :: Oid
- _numrange :: TypeInfo
- _numrangeOid :: Oid
- tsrange :: TypeInfo
- tsrangeOid :: Oid
- _tsrange :: TypeInfo
- _tsrangeOid :: Oid
- tstzrange :: TypeInfo
- tstzrangeOid :: Oid
- _tstzrange :: TypeInfo
- _tstzrangeOid :: Oid
- daterange :: TypeInfo
- daterangeOid :: Oid
- _daterange :: TypeInfo
- _daterangeOid :: Oid
- int8range :: TypeInfo
- int8rangeOid :: Oid
- _int8range :: TypeInfo
- _int8rangeOid :: Oid

# Documentation

data TypeInfo Source #

A structure representing some of the metadata regarding a PostgreSQL type, mostly taken from the `pg_type` table.

Constructors

Basic |

Fields

- typoid :: !Oid
- typcategory :: !Char
- typdelim :: !Char
- typname :: !ByteString

Array |

Fields

- typoid :: !Oid
- typcategory :: !Char
- typdelim :: !Char
- typname :: !ByteString
- typelem :: !TypeInfo

Range |

Fields

- typoid :: !Oid
- typcategory :: !Char
- typdelim :: !Char
- typname :: !ByteString
- rngsubtype :: !TypeInfo

Composite |

Fields

- typoid :: !Oid
- typcategory :: !Char
- typdelim :: !Char
- typname :: !ByteString
- typrelid :: !Oid
- attributes :: !(Vector Attribute)

#### Instances

Instances details

Show TypeInfo Source # |
Instance details Defined in Database.PostgreSQL.Simple.TypeInfo.Types Methods showsPrec :: Int -> TypeInfo -> ShowS Source # show :: TypeInfo -> String Source # showList :: [TypeInfo] -> ShowS Source #

staticTypeInfo :: Oid -> Maybe TypeInfo Source #

bool :: TypeInfo Source #

boolOid :: Oid Source #

bytea :: TypeInfo Source #

byteaOid :: Oid Source #

char :: TypeInfo Source #

charOid :: Oid Source #

name :: TypeInfo Source #

nameOid :: Oid Source #

int8 :: TypeInfo Source #

int8Oid :: Oid Source #

int2 :: TypeInfo Source #

int2Oid :: Oid Source #

int4 :: TypeInfo Source #

int4Oid :: Oid Source #

regproc :: TypeInfo Source #

regprocOid :: Oid Source #

text :: TypeInfo Source #

textOid :: Oid Source #

oid :: TypeInfo Source #

oidOid :: Oid Source #

tid :: TypeInfo Source #

tidOid :: Oid Source #

xid :: TypeInfo Source #

xidOid :: Oid Source #

cid :: TypeInfo Source #

cidOid :: Oid Source #

xml :: TypeInfo Source #

xmlOid :: Oid Source #

point :: TypeInfo Source #

pointOid :: Oid Source #

lseg :: TypeInfo Source #

lsegOid :: Oid Source #

path :: TypeInfo Source #

pathOid :: Oid Source #

box :: TypeInfo Source #

boxOid :: Oid Source #

polygon :: TypeInfo Source #

polygonOid :: Oid Source #

line :: TypeInfo Source #

lineOid :: Oid Source #

cidr :: TypeInfo Source #

cidrOid :: Oid Source #

float4 :: TypeInfo Source #

float4Oid :: Oid Source #

float8 :: TypeInfo Source #

float8Oid :: Oid Source #

unknown :: TypeInfo Source #

unknownOid :: Oid Source #

circle :: TypeInfo Source #

circleOid :: Oid Source #

money :: TypeInfo Source #

moneyOid :: Oid Source #

macaddr :: TypeInfo Source #

macaddrOid :: Oid Source #

inet :: TypeInfo Source #

inetOid :: Oid Source #

bpchar :: TypeInfo Source #

bpcharOid :: Oid Source #

varchar :: TypeInfo Source #

varcharOid :: Oid Source #

date :: TypeInfo Source #

dateOid :: Oid Source #

time :: TypeInfo Source #

timeOid :: Oid Source #

timestamp :: TypeInfo Source #

timestampOid :: Oid Source #

timestamptz :: TypeInfo Source #

timestamptzOid :: Oid Source #

interval :: TypeInfo Source #

intervalOid :: Oid Source #

timetz :: TypeInfo Source #

timetzOid :: Oid Source #

bit :: TypeInfo Source #

bitOid :: Oid Source #

varbit :: TypeInfo Source #

varbitOid :: Oid Source #

numeric :: TypeInfo Source #

numericOid :: Oid Source #

refcursor :: TypeInfo Source #

refcursorOid :: Oid Source #

record :: TypeInfo Source #

recordOid :: Oid Source #

void :: TypeInfo Source #

voidOid :: Oid Source #

array_record :: TypeInfo Source #

array_recordOid :: Oid Source #

regprocedure :: TypeInfo Source #

regprocedureOid :: Oid Source #

regoper :: TypeInfo Source #

regoperOid :: Oid Source #

regoperator :: TypeInfo Source #

regoperatorOid :: Oid Source #

regclass :: TypeInfo Source #

regclassOid :: Oid Source #

regtype :: TypeInfo Source #

regtypeOid :: Oid Source #

uuid :: TypeInfo Source #

uuidOid :: Oid Source #

json :: TypeInfo Source #

jsonOid :: Oid Source #

jsonb :: TypeInfo Source #

jsonbOid :: Oid Source #

int2vector :: TypeInfo Source #

int2vectorOid :: Oid Source #

oidvector :: TypeInfo Source #

oidvectorOid :: Oid Source #

array_xml :: TypeInfo Source #

array_xmlOid :: Oid Source #

array_json :: TypeInfo Source #

array_jsonOid :: Oid Source #

array_line :: TypeInfo Source #

array_lineOid :: Oid Source #

array_cidr :: TypeInfo Source #

array_cidrOid :: Oid Source #

array_circle :: TypeInfo Source #

array_circleOid :: Oid Source #

array_money :: TypeInfo Source #

array_moneyOid :: Oid Source #

array_bool :: TypeInfo Source #

array_boolOid :: Oid Source #

array_bytea :: TypeInfo Source #

array_byteaOid :: Oid Source #

array_char :: TypeInfo Source #

array_charOid :: Oid Source #

array_name :: TypeInfo Source #

array_nameOid :: Oid Source #

array_int2 :: TypeInfo Source #

array_int2Oid :: Oid Source #

array_int2vector :: TypeInfo Source #

array_int2vectorOid :: Oid Source #

array_int4 :: TypeInfo Source #

array_int4Oid :: Oid Source #

array_regproc :: TypeInfo Source #

array_regprocOid :: Oid Source #

array_text :: TypeInfo Source #

array_textOid :: Oid Source #

array_tid :: TypeInfo Source #

array_tidOid :: Oid Source #

array_xid :: TypeInfo Source #

array_xidOid :: Oid Source #

array_cid :: TypeInfo Source #

array_cidOid :: Oid Source #

array_oidvector :: TypeInfo Source #

array_oidvectorOid :: Oid Source #

array_bpchar :: TypeInfo Source #

array_bpcharOid :: Oid Source #

array_varchar :: TypeInfo Source #

array_varcharOid :: Oid Source #

array_int8 :: TypeInfo Source #

array_int8Oid :: Oid Source #

array_point :: TypeInfo Source #

array_pointOid :: Oid Source #

array_lseg :: TypeInfo Source #

array_lsegOid :: Oid Source #

array_path :: TypeInfo Source #

array_pathOid :: Oid Source #

array_box :: TypeInfo Source #

array_boxOid :: Oid Source #

array_float4 :: TypeInfo Source #

array_float4Oid :: Oid Source #

array_float8 :: TypeInfo Source #

array_float8Oid :: Oid Source #

array_polygon :: TypeInfo Source #

array_polygonOid :: Oid Source #

array_oid :: TypeInfo Source #

array_oidOid :: Oid Source #

array_macaddr :: TypeInfo Source #

array_macaddrOid :: Oid Source #

array_inet :: TypeInfo Source #

array_inetOid :: Oid Source #

array_timestamp :: TypeInfo Source #

array_timestampOid :: Oid Source #

array_date :: TypeInfo Source #

array_dateOid :: Oid Source #

array_time :: TypeInfo Source #

array_timeOid :: Oid Source #

array_timestamptz :: TypeInfo Source #

array_timestamptzOid :: Oid Source #

array_interval :: TypeInfo Source #

array_intervalOid :: Oid Source #

array_numeric :: TypeInfo Source #

array_numericOid :: Oid Source #

array_timetz :: TypeInfo Source #

array_timetzOid :: Oid Source #

array_bit :: TypeInfo Source #

array_bitOid :: Oid Source #

array_varbit :: TypeInfo Source #

array_varbitOid :: Oid Source #

array_refcursor :: TypeInfo Source #

array_refcursorOid :: Oid Source #

array_regprocedure :: TypeInfo Source #

array_regprocedureOid :: Oid Source #

array_regoper :: TypeInfo Source #

array_regoperOid :: Oid Source #

array_regoperator :: TypeInfo Source #

array_regoperatorOid :: Oid Source #

array_regclass :: TypeInfo Source #

array_regclassOid :: Oid Source #

array_regtype :: TypeInfo Source #

array_regtypeOid :: Oid Source #

array_uuid :: TypeInfo Source #

array_uuidOid :: Oid Source #

array_jsonb :: TypeInfo Source #

array_jsonbOid :: Oid Source #

int4range :: TypeInfo Source #

int4rangeOid :: Oid Source #

_int4range :: TypeInfo Source #

_int4rangeOid :: Oid Source #

numrange :: TypeInfo Source #

numrangeOid :: Oid Source #

_numrange :: TypeInfo Source #

_numrangeOid :: Oid Source #

tsrange :: TypeInfo Source #

tsrangeOid :: Oid Source #

_tsrange :: TypeInfo Source #

_tsrangeOid :: Oid Source #

tstzrange :: TypeInfo Source #

tstzrangeOid :: Oid Source #

_tstzrange :: TypeInfo Source #

_tstzrangeOid :: Oid Source #

daterange :: TypeInfo Source #

daterangeOid :: Oid Source #

_daterange :: TypeInfo Source #

_daterangeOid :: Oid Source #

int8range :: TypeInfo Source #

int8rangeOid :: Oid Source #

_int8range :: TypeInfo Source #

_int8rangeOid :: Oid Source #