Structure
PostgresDataType
Data types and their raw OIDs.
struct PostgresDataTypeOverview
Use select * from pg_type where oid = <idhere> to look up more information for a given type.
This list was generated by running select oid, typname from pg_type where oid < 10000 order by oid and manually trimming Postgres-internal types.
Topics
Initializers
init(UInt32)init?(rawValue: UInt32)Creates a new instance with the specified raw value.
Instance Properties
var description: StringA textual representation of this instance.var isUserDefined: BoolReturnstrueif the type’s raw value is greater than or equal to2^14. This appears to be true for all user-defined types, but I don’t have any documentation to back this up.var knownSQLName: String?Returns the known SQL name, if one exists. Note: This only supports a limited subset of all PSQL types and is meant for convenience only. This list was manually generated.var rawValue: UInt32The raw data type code recognized by PostgreSQL.
Type Properties
static let aclitem: PostgresDataType1033static let aclitemArray: PostgresDataType1034_aclitemstatic let any: PostgresDataType2276static let anyarray: PostgresDataType2277static let anycompatible: PostgresDataType5077static let anycompatiblearray: PostgresDataType5078static let anycompatiblemultirange: PostgresDataType4538static let anycompatiblenonarray: PostgresDataType5079static let anycompatiblerange: PostgresDataType5080static let anyelement: PostgresDataType2283static let anyenum: PostgresDataType3500static let anymultirange: PostgresDataType4537static let anynonarray: PostgresDataType2776static let anyrange: PostgresDataType3831static let bit: PostgresDataType1560static let bitArray: PostgresDataType1561static let bool: PostgresDataType16static let boolArray: PostgresDataType1000_boolstatic let box: PostgresDataType603static let boxArray: PostgresDataType1020static let bpchar: PostgresDataType1042static let bpcharArray: PostgresDataType1014static let bytea: PostgresDataType17static let byteaArray: PostgresDataType1001_byteastatic let char: PostgresDataType18static let charArray: PostgresDataType1002_charstatic let cid: PostgresDataType29static let cidArray: PostgresDataType1012static let cidr: PostgresDataType650static let cidrArray: PostgresDataType651static let circle: PostgresDataType718static let circleArray: PostgresDataType719static let cstring: PostgresDataType2275static let cstringArray: PostgresDataType1263static let date: PostgresDataType1082static let dateArray: PostgresDataType1182static let datemultirange: PostgresDataType4535static let datemultirangeArray: PostgresDataType6155static let daterange: PostgresDataType3912static let daterangeArray: PostgresDataType3913static let eventTrigger: PostgresDataType3838static let fdwHandler: PostgresDataType3115static let float4: PostgresDataType700static let float4Array: PostgresDataType1021_float4static let float8: PostgresDataType701static let float8Array: PostgresDataType1022_float8static let gtsvector: PostgresDataType3642static let gtsvectorArray: PostgresDataType3644static let indexAMHandler: PostgresDataType325static let inet: PostgresDataType869static let inetArray: PostgresDataType1041static let int2: PostgresDataType21static let int2Array: PostgresDataType1005_int2static let int2vector: PostgresDataType22static let int2vectorArray: PostgresDataType1006static let int4: PostgresDataType23static let int4Array: PostgresDataType1007_int4static let int4Range: PostgresDataType3904static let int4RangeArray: PostgresDataType3905_int4rangestatic let int4multirange: PostgresDataType4451static let int4multirangeArray: PostgresDataType6150static let int8: PostgresDataType20static let int8Array: PostgresDataType1016_int8static let int8Range: PostgresDataType3926static let int8RangeArray: PostgresDataType3927_int8rangestatic let int8multirange: PostgresDataType4536static let int8multirangeArray: PostgresDataType6157static let `internal`: PostgresDataType2281static let interval: PostgresDataType1186static let intervalArray: PostgresDataType1187static let json: PostgresDataType114static let jsonArray: PostgresDataType199static let jsonb: PostgresDataType3802static let jsonbArray: PostgresDataType3807_jsonbstatic let jsonpath: PostgresDataType4072static let jsonpathArray: PostgresDataType4073static let languageHandler: PostgresDataType2280static let line: PostgresDataType628static let lineArray: PostgresDataType629static let lseg: PostgresDataType601static let lsegArray: PostgresDataType1018static let macaddr: PostgresDataType829static let macaddr8: PostgresDataType774static let macaddr8Aray: PostgresDataType775static let macaddr8Array: PostgresDataTypestatic let macaddrArray: PostgresDataType1040static let money: PostgresDataType790static let moneyArray: PostgresDataTypestatic let name: PostgresDataType19static let nameArray: PostgresDataType1003_namestatic let null: PostgresDataType0static let numeric: PostgresDataType1700static let numericArray: PostgresDataType1231static let nummultirange: PostgresDataType4532static let nummultirangeArray: PostgresDataType6151static let numrange: PostgresDataType3906static let numrangeArray: PostgresDataType3907static let oid: PostgresDataType26static let oidArray: PostgresDataType1028static let oidvector: PostgresDataType30static let oidvectorArray: PostgresDataType1013static let path: PostgresDataType602static let pathArray: PostgresDataType1019static let pgDDLCommand: PostgresDataType32static let pgLSN: PostgresDataType3220static let pgLSNArray: PostgresDataType3221static let pgNodeTree: PostgresDataType194pg_node_treestatic let point: PostgresDataType600static let pointArray: PostgresDataType1017_pointstatic let polygon: PostgresDataType604static let polygonArray: PostgresDataType1027static let record: PostgresDataType2249static let recordArray: PostgresDataType2287static let refcursor: PostgresDataType1790static let refcursorArray: PostgresDataType2201static let regclass: PostgresDataType2205static let regclassArray: PostgresDataType2210static let regcollation: PostgresDataType4191static let regcollationArray: PostgresDataType4192static let regconfig: PostgresDataType3734static let regconfigArray: PostgresDataType3735static let regdictionary: PostgresDataType3769static let regdictionaryArray: PostgresDataType3770static let regnamespace: PostgresDataType4089static let regnamespaceArray: PostgresDataType4090static let regoper: PostgresDataType2203static let regoperArray: PostgresDataType2208static let regoperator: PostgresDataType2204static let regoperatorArray: PostgresDataType2209static let regproc: PostgresDataType24static let regprocArray: PostgresDataType1008static let regprocedure: PostgresDataType2202static let regprocedureArray: PostgresDataType2207static let regrole: PostgresDataType4096static let regroleArray: PostgresDataType4097static let regtype: PostgresDataType2206static let regtypeArray: PostgresDataType2211static let tableAMHandler: PostgresDataType269static let text: PostgresDataType25static let textArray: PostgresDataType1009_textstatic let tid: PostgresDataType27static let tidArray: PostgresDataType1010static let time: PostgresDataType1083static let timeArray: PostgresDataType1183static let timestamp: PostgresDataType1114static let timestampArray: PostgresDataType1115_timestampstatic let timestamptz: PostgresDataType1184static let timestamptzArray: PostgresDataType1185static let timetz: PostgresDataType1266static let timetzArray: PostgresDataType1270static let trigger: PostgresDataType2279static let tsmHandler: PostgresDataType3310static let tsmultirange: PostgresDataType4533static let tsmultirangeArray: PostgresDataType6152static let tsquery: PostgresDataType3615static let tsqueryArray: PostgresDataType3645static let tsrange: PostgresDataType3908static let tsrangeArray: PostgresDataType3909static let tstzmultirange: PostgresDataType4534static let tstzmultirangeArray: PostgresDataType6153static let tstzrange: PostgresDataType3910static let tstzrangeArray: PostgresDataType3911static let tsvector: PostgresDataType3614static let tsvectorArray: PostgresDataType3643static let unknown: PostgresDataType705static let uuid: PostgresDataType2950static let uuidArray: PostgresDataType2951_uuidstatic let varbit: PostgresDataType1562static let varbitArray: PostgresDataType1563static let varchar: PostgresDataType1043static let varcharArray: PostgresDataType1015_varcharstatic let void: PostgresDataType2278static let xid: PostgresDataType28static let xid8: PostgresDataType5069static let xid8Array: PostgresDataType271static let xidArray: PostgresDataType1011static let xml: PostgresDataType142static let xmlArray: PostgresDataType143
Default Implementations
Relationships
Conforms To
PostgresArrayDecodablePostgresArrayEncodablePostgresDecodablePostgresDynamicTypeEncodablePostgresEncodablePostgresNonThrowingEncodablePostgresThrowingDynamicTypeEncodableSwift.CopyableSwift.CustomStringConvertibleSwift.DecodableSwift.EncodableSwift.EquatableSwift.EscapableSwift.ExpressibleByIntegerLiteralSwift.HashableSwift.RawRepresentableSwift.SendableSwift.SendableMetatype
See Also
Essentials
typealias PostgresCodableA type that can be encoded into and decoded from a Postgres binary format.enum PostgresFormatThe format the postgres types are encoded in on the wire.struct PostgresNumeric