package pgtype

Import Path
	github.com/jackc/pgtype (on go.dev)

Dependency Relation
	imports 19 packages, and imported by 2 packages


Package-Level Type Names (total 120, in which 104 are exported)
/* sort exporteds by: | */
ACLItem is used for PostgreSQL's aclitem data type. A sample aclitem might look like this: postgres=arwdDxt/postgres Note, however, that because the user/role name part of an aclitem is an identifier, it follows all the usual formatting rules for SQL identifiers: if it contains spaces and other special characters, it should appear in double-quotes: postgres=arwdDxt/"role with spaces" Status Status String string (*T) AssignTo(dst interface{}) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : TextDecoder T : TextEncoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []ACLItem Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : TextDecoder T : TextEncoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
Length int32 LowerBound int32 func EncodeTextArrayDimensions(buf []byte, dimensions []ArrayDimension) []byte
ContainsNull bool Dimensions []ArrayDimension ElementOID int32 (*T) DecodeBinary(ci *ConnInfo, src []byte) (int, error) ( T) EncodeBinary(ci *ConnInfo, buf []byte) []byte
ArrayType represents an array type. While it implements Value, this is only in service of its type conversion duties when registered as a data type in a ConnType. It should not be used directly as a Value. ArrayType is a convenience type for types that do not have an concrete array type. (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} (*T) NewTypeValue() Value Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) TypeName() string Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : TypeValue *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer func NewArrayType(typeName string, elementOID uint32, newElement func() ValueTranscoder) *ArrayType
DecodeBinary decodes src into BinaryDecoder. If src is nil then the original SQL value is NULL. BinaryDecoder takes ownership of src. The caller MUST not use it again. *ArrayType *Bit *Bool *BoolArray *Box *BPChar *BPCharArray *Bytea *ByteaArray *CID *CIDR *CIDRArray *Circle CompositeFields *CompositeType *Date *DateArray *Daterange *EnumType *Float4 *Float4Array *Float8 *Float8Array *GenericBinary *Hstore *HstoreArray *Inet *InetArray *Int2 *Int2Array *Int4 *Int4Array *Int4range *Int8 *Int8Array *Int8range *Interval *JSON *JSONB *JSONBArray *Line *Lseg *Macaddr *MacaddrArray *Name *Numeric *NumericArray *Numrange *OID *OIDValue *Path *Point *Polygon *QChar *Record *Text *TextArray *TID *Time *Timestamp *TimestampArray *Timestamptz *TimestamptzArray *Tsrange *TsrangeArray *Tstzrange *TstzrangeArray *Unknown *UUID *UUIDArray ValueTranscoder (interface) *Varbit *Varchar *VarcharArray *XID func (*CompositeBinaryScanner).ScanDecoder(d BinaryDecoder)
BinaryEncoder is implemented by types that can encode themselves into the PostgreSQL binary wire format. EncodeBinary should append the binary format of self to buf. If self is the SQL value NULL then append nothing and return (nil, nil). The caller of EncodeBinary is responsible for writing the correct NULL value or the length of the data written. ArrayType Bit Bool BoolArray Box BPChar BPCharArray Bytea ByteaArray CID CIDR CIDRArray Circle CompositeFields CompositeType Date DateArray Daterange EnumType Float4 Float4Array Float8 Float8Array GenericBinary Hstore HstoreArray Inet InetArray Int2 Int2Array Int4 Int4Array Int4range Int8 Int8Array Int8range Interval JSON JSONB JSONBArray Line Lseg Macaddr MacaddrArray Name Numeric NumericArray Numrange OID OIDValue Path Point Polygon QChar Text TextArray TID Time Timestamp TimestampArray Timestamptz TimestamptzArray Tsrange TsrangeArray Tstzrange TstzrangeArray UUID UUIDArray ValueTranscoder (interface) Varbit Varchar VarcharArray XID func (*CompositeBinaryBuilder).AppendEncoder(oid uint32, field BinaryEncoder)
Bytes []byte // Number of bits Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Bool bool Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Bool Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
( T) String() string T : expvar.Var T : fmt.Stringer const Empty const Exclusive const Inclusive const Unbounded
P [2]Vec2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
BPChar is fixed-length, blank padded char type character(n), char(n) Status Status String string AssignTo assigns from src to dst. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) Get returns underlying value ( T) MarshalJSON() ([]byte, error) ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Scan implements the database/sql Scanner interface. Set converts from src to dst. (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []BPChar Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Bytes []byte Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error DecodeText only supports the hex format. This has been the default since PostgreSQL 9.0. ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Bytea Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
CID is PostgreSQL's Command Identifier type. When one does select cmin, cmax, * from some_table; it is the data type of the cmin and cmax hidden system columns. It is currently implemented as an unsigned four byte integer. Its definition can be found in src/include/c.h as CommandId in the PostgreSQL sources. Status Status Uint uint32 AssignTo assigns from src to dst. Note that as CID is not a general number type AssignTo does not do automatic type conversion as other number types do. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts from src to dst. Note that as CID is not a general number type Set does not do automatic type conversion as other number types do. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
IPNet *net.IPNet Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} (*T) Set(src interface{}) error *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder
Dimensions []ArrayDimension Elements []CIDR Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
P Vec2 R float64 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
(*T) AppendEncoder(oid uint32, field BinaryEncoder) (*T) AppendValue(oid uint32, field interface{}) (*T) Finish() ([]byte, error) func NewCompositeBinaryBuilder(ci *ConnInfo, buf []byte) *CompositeBinaryBuilder
Bytes returns the bytes of the field most recently read by Scan(). Err returns any error encountered by the scanner. (*T) FieldCount() int Next advances the scanner to the next field. It returns false after the last field is read or an error occurs. After Next returns false, the Err method can be called to check if any errors occurred. OID returns the OID of the field most recently read by Scan(). ScanDecoder calls Next and decodes the result with d. ScanDecoder calls Next and scans the result into d. func NewCompositeBinaryScanner(ci *ConnInfo, src []byte) *CompositeBinaryScanner
CompositeFields scans the fields of a composite type into the elements of the CompositeFields value. To scan a nullable value use a *CompositeFields. It will be set to nil in case of null. CompositeFields implements EncodeBinary and EncodeText. However, functionality is limited due to CompositeFields not knowing the PostgreSQL schema of the composite type. Prefer using a registered CompositeType. ( T) DecodeBinary(ci *ConnInfo, src []byte) error ( T) DecodeText(ci *ConnInfo, src []byte) error EncodeBinary encodes composite fields into the binary format. Unlike CompositeType the schema of the destination is unknown. Prefer registering a CompositeType to using CompositeFields to encode directly. Because the binary composite format requires the OID of each field to be specified the only types that will work are those known to ConnInfo. In particular: * Nil cannot be used because there is no way to determine what type it. * Integer types must be exact matches. e.g. A Go int32 into a PostgreSQL bigint will fail. * No dereferencing will be done. e.g. *Text must be used instead of Text. EncodeText encodes composite fields into the text format. Prefer registering a CompositeType to using CompositeFields to encode directly. T : BinaryDecoder T : BinaryEncoder T : TextDecoder T : TextEncoder
(*T) AppendEncoder(field TextEncoder) (*T) AppendValue(field interface{}) (*T) Finish() ([]byte, error) func NewCompositeTextBuilder(ci *ConnInfo, buf []byte) *CompositeTextBuilder
Bytes returns the bytes of the field most recently read by Scan(). Err returns any error encountered by the scanner. Next advances the scanner to the next field. It returns false after the last field is read or an error occurs. After Next returns false, the Err method can be called to check if any errors occurred. ScanDecoder calls Next and decodes the result with d. ScanDecoder calls Next and scans the result into d. func NewCompositeTextScanner(ci *ConnInfo, src []byte) *CompositeTextScanner
AssignTo should never be called on composite value directly DecodeBinary implements BinaryDecoder interface. Opposite to Record, fields in a composite act as a "schema" and decoding fails if SQL value can't be assigned due to type mismatch (*T) DecodeText(ci *ConnInfo, buf []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) (newBuf []byte, err error) ( T) EncodeText(ci *ConnInfo, buf []byte) (newBuf []byte, err error) (*T) Fields() []CompositeTypeField ( T) Get() interface{} (*T) NewTypeValue() Value (*T) Set(src interface{}) error (*T) TypeName() string *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : TypeValue *T : Value *T : ValueTranscoder func NewCompositeType(typeName string, fields []CompositeTypeField, ci *ConnInfo) (*CompositeType, error) func NewCompositeTypeValues(typeName string, fields []CompositeTypeField, values []ValueTranscoder) (*CompositeType, error)
Name string OID uint32 func (*CompositeType).Fields() []CompositeTypeField func NewCompositeType(typeName string, fields []CompositeTypeField, ci *ConnInfo) (*CompositeType, error) func NewCompositeTypeValues(typeName string, fields []CompositeTypeField, values []ValueTranscoder) (*CompositeType, error)
(*T) DataTypeForName(name string) (*DataType, bool) (*T) DataTypeForOID(oid uint32) (*DataType, bool) DataTypeForValue finds a data type suitable for v. Use RegisterDataType to register types that can encode and decode themselves. Use RegisterDefaultPgType to register that can be handled by a registered data type. DeepCopy makes a deep copy of the ConnInfo. (*T) InitializeDataTypes(nameOIDs map[string]uint32) (*T) ParamFormatCodeForOID(oid uint32) int16 PlanScan prepares a plan to scan a value into dst. (*T) RegisterDataType(t DataType) RegisterDefaultPgType registers a mapping of a Go type to a PostgreSQL type name. Typically the data type to be encoded or decoded is determined by the PostgreSQL OID. But if the OID of a value to be encoded or decoded is unknown, this additional mapping will be used by DataTypeForValue to determine a suitable data type. (*T) ResultFormatCodeForOID(oid uint32) int16 (*T) Scan(oid uint32, formatCode int16, src []byte, dst interface{}) error func NewConnInfo() *ConnInfo func (*ConnInfo).DeepCopy() *ConnInfo func github.com/jackc/pgx/v4.(*Conn).ConnInfo() *ConnInfo func DatabaseSQLValue(ci *ConnInfo, src Value) (interface{}, error) func NewCompositeBinaryBuilder(ci *ConnInfo, buf []byte) *CompositeBinaryBuilder func NewCompositeBinaryScanner(ci *ConnInfo, src []byte) *CompositeBinaryScanner func NewCompositeTextBuilder(ci *ConnInfo, buf []byte) *CompositeTextBuilder func NewCompositeTextScanner(ci *ConnInfo, src []byte) *CompositeTextScanner func NewCompositeType(typeName string, fields []CompositeTypeField, ci *ConnInfo) (*CompositeType, error) func (*ACLItem).DecodeText(ci *ConnInfo, src []byte) error func ACLItem.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*ACLItemArray).DecodeText(ci *ConnInfo, src []byte) error func ACLItemArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*ArrayHeader).DecodeBinary(ci *ConnInfo, src []byte) (int, error) func ArrayHeader.EncodeBinary(ci *ConnInfo, buf []byte) []byte func (*ArrayType).DecodeBinary(ci *ConnInfo, src []byte) error func (*ArrayType).DecodeText(ci *ConnInfo, src []byte) error func ArrayType.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func ArrayType.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func BinaryDecoder.DecodeBinary(ci *ConnInfo, src []byte) error func BinaryEncoder.EncodeBinary(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func (*Bit).DecodeBinary(ci *ConnInfo, src []byte) error func (*Bit).DecodeText(ci *ConnInfo, src []byte) error func Bit.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Bit.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Bool).DecodeBinary(ci *ConnInfo, src []byte) error func (*Bool).DecodeText(ci *ConnInfo, src []byte) error func Bool.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Bool.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*BoolArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*BoolArray).DecodeText(ci *ConnInfo, src []byte) error func BoolArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func BoolArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Box).DecodeBinary(ci *ConnInfo, src []byte) error func (*Box).DecodeText(ci *ConnInfo, src []byte) error func Box.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Box.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*BPChar).DecodeBinary(ci *ConnInfo, src []byte) error func (*BPChar).DecodeText(ci *ConnInfo, src []byte) error func BPChar.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func BPChar.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*BPCharArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*BPCharArray).DecodeText(ci *ConnInfo, src []byte) error func BPCharArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func BPCharArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Bytea).DecodeBinary(ci *ConnInfo, src []byte) error func (*Bytea).DecodeText(ci *ConnInfo, src []byte) error func Bytea.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Bytea.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*ByteaArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*ByteaArray).DecodeText(ci *ConnInfo, src []byte) error func ByteaArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func ByteaArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*CID).DecodeBinary(ci *ConnInfo, src []byte) error func (*CID).DecodeText(ci *ConnInfo, src []byte) error func CID.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func CID.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*CIDR).DecodeBinary(ci *ConnInfo, src []byte) error func (*CIDR).DecodeText(ci *ConnInfo, src []byte) error func CIDR.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func CIDR.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*CIDRArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*CIDRArray).DecodeText(ci *ConnInfo, src []byte) error func CIDRArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func CIDRArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Circle).DecodeBinary(ci *ConnInfo, src []byte) error func (*Circle).DecodeText(ci *ConnInfo, src []byte) error func Circle.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Circle.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func CompositeFields.DecodeBinary(ci *ConnInfo, src []byte) error func CompositeFields.DecodeText(ci *ConnInfo, src []byte) error func CompositeFields.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func CompositeFields.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*CompositeType).DecodeBinary(ci *ConnInfo, buf []byte) error func (*CompositeType).DecodeText(ci *ConnInfo, buf []byte) error func CompositeType.EncodeBinary(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func CompositeType.EncodeText(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func (*Date).DecodeBinary(ci *ConnInfo, src []byte) error func (*Date).DecodeText(ci *ConnInfo, src []byte) error func Date.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Date.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*DateArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*DateArray).DecodeText(ci *ConnInfo, src []byte) error func DateArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func DateArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Daterange).DecodeBinary(ci *ConnInfo, src []byte) error func (*Daterange).DecodeText(ci *ConnInfo, src []byte) error func Daterange.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Daterange.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*EnumArray).DecodeText(ci *ConnInfo, src []byte) error func EnumArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*EnumType).DecodeBinary(ci *ConnInfo, src []byte) error func (*EnumType).DecodeText(ci *ConnInfo, src []byte) error func EnumType.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func EnumType.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Float4).DecodeBinary(ci *ConnInfo, src []byte) error func (*Float4).DecodeText(ci *ConnInfo, src []byte) error func Float4.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Float4.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Float4Array).DecodeBinary(ci *ConnInfo, src []byte) error func (*Float4Array).DecodeText(ci *ConnInfo, src []byte) error func Float4Array.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Float4Array.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Float8).DecodeBinary(ci *ConnInfo, src []byte) error func (*Float8).DecodeText(ci *ConnInfo, src []byte) error func Float8.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Float8.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Float8Array).DecodeBinary(ci *ConnInfo, src []byte) error func (*Float8Array).DecodeText(ci *ConnInfo, src []byte) error func Float8Array.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Float8Array.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*GenericBinary).DecodeBinary(ci *ConnInfo, src []byte) error func GenericBinary.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func (*GenericText).DecodeText(ci *ConnInfo, src []byte) error func GenericText.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Hstore).DecodeBinary(ci *ConnInfo, src []byte) error func (*Hstore).DecodeText(ci *ConnInfo, src []byte) error func Hstore.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Hstore.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*HstoreArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*HstoreArray).DecodeText(ci *ConnInfo, src []byte) error func HstoreArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func HstoreArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Inet).DecodeBinary(ci *ConnInfo, src []byte) error func (*Inet).DecodeText(ci *ConnInfo, src []byte) error func Inet.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Inet.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*InetArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*InetArray).DecodeText(ci *ConnInfo, src []byte) error func InetArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func InetArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int2).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int2).DecodeText(ci *ConnInfo, src []byte) error func Int2.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int2.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int2Array).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int2Array).DecodeText(ci *ConnInfo, src []byte) error func Int2Array.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int2Array.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int4).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int4).DecodeText(ci *ConnInfo, src []byte) error func Int4.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int4.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int4Array).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int4Array).DecodeText(ci *ConnInfo, src []byte) error func Int4Array.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int4Array.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int4range).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int4range).DecodeText(ci *ConnInfo, src []byte) error func Int4range.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int4range.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int8).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int8).DecodeText(ci *ConnInfo, src []byte) error func Int8.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int8.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int8Array).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int8Array).DecodeText(ci *ConnInfo, src []byte) error func Int8Array.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int8Array.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Int8range).DecodeBinary(ci *ConnInfo, src []byte) error func (*Int8range).DecodeText(ci *ConnInfo, src []byte) error func Int8range.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Int8range.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Interval).DecodeBinary(ci *ConnInfo, src []byte) error func (*Interval).DecodeText(ci *ConnInfo, src []byte) error func Interval.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Interval.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*JSON).DecodeBinary(ci *ConnInfo, src []byte) error func (*JSON).DecodeText(ci *ConnInfo, src []byte) error func JSON.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func JSON.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*JSONB).DecodeBinary(ci *ConnInfo, src []byte) error func (*JSONB).DecodeText(ci *ConnInfo, src []byte) error func JSONB.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func JSONB.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*JSONBArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*JSONBArray).DecodeText(ci *ConnInfo, src []byte) error func JSONBArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func JSONBArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Line).DecodeBinary(ci *ConnInfo, src []byte) error func (*Line).DecodeText(ci *ConnInfo, src []byte) error func Line.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Line.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Lseg).DecodeBinary(ci *ConnInfo, src []byte) error func (*Lseg).DecodeText(ci *ConnInfo, src []byte) error func Lseg.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Lseg.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Macaddr).DecodeBinary(ci *ConnInfo, src []byte) error func (*Macaddr).DecodeText(ci *ConnInfo, src []byte) error func Macaddr.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Macaddr.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*MacaddrArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*MacaddrArray).DecodeText(ci *ConnInfo, src []byte) error func MacaddrArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func MacaddrArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Name).DecodeBinary(ci *ConnInfo, src []byte) error func (*Name).DecodeText(ci *ConnInfo, src []byte) error func Name.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Name.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Numeric).DecodeBinary(ci *ConnInfo, src []byte) error func (*Numeric).DecodeText(ci *ConnInfo, src []byte) error func Numeric.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Numeric.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*NumericArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*NumericArray).DecodeText(ci *ConnInfo, src []byte) error func NumericArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func NumericArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Numrange).DecodeBinary(ci *ConnInfo, src []byte) error func (*Numrange).DecodeText(ci *ConnInfo, src []byte) error func Numrange.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Numrange.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*OID).DecodeBinary(ci *ConnInfo, src []byte) error func (*OID).DecodeText(ci *ConnInfo, src []byte) error func OID.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func OID.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*OIDValue).DecodeBinary(ci *ConnInfo, src []byte) error func (*OIDValue).DecodeText(ci *ConnInfo, src []byte) error func OIDValue.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func OIDValue.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Path).DecodeBinary(ci *ConnInfo, src []byte) error func (*Path).DecodeText(ci *ConnInfo, src []byte) error func Path.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Path.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Point).DecodeBinary(ci *ConnInfo, src []byte) error func (*Point).DecodeText(ci *ConnInfo, src []byte) error func Point.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Point.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Polygon).DecodeBinary(ci *ConnInfo, src []byte) error func (*Polygon).DecodeText(ci *ConnInfo, src []byte) error func Polygon.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Polygon.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*QChar).DecodeBinary(ci *ConnInfo, src []byte) error func QChar.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func (*Record).DecodeBinary(ci *ConnInfo, src []byte) error func ScanPlan.Scan(ci *ConnInfo, oid uint32, formatCode int16, src []byte, dst interface{}) error func (*Text).DecodeBinary(ci *ConnInfo, src []byte) error func (*Text).DecodeText(ci *ConnInfo, src []byte) error func Text.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Text.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*TextArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*TextArray).DecodeText(ci *ConnInfo, src []byte) error func TextArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TextArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func TextDecoder.DecodeText(ci *ConnInfo, src []byte) error func TextEncoder.EncodeText(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func (*TID).DecodeBinary(ci *ConnInfo, src []byte) error func (*TID).DecodeText(ci *ConnInfo, src []byte) error func TID.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TID.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Time).DecodeBinary(ci *ConnInfo, src []byte) error func (*Time).DecodeText(ci *ConnInfo, src []byte) error func Time.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Time.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Timestamp).DecodeBinary(ci *ConnInfo, src []byte) error func (*Timestamp).DecodeText(ci *ConnInfo, src []byte) error func Timestamp.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Timestamp.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*TimestampArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*TimestampArray).DecodeText(ci *ConnInfo, src []byte) error func TimestampArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TimestampArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Timestamptz).DecodeBinary(ci *ConnInfo, src []byte) error func (*Timestamptz).DecodeText(ci *ConnInfo, src []byte) error func Timestamptz.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Timestamptz.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*TimestamptzArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*TimestamptzArray).DecodeText(ci *ConnInfo, src []byte) error func TimestamptzArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TimestamptzArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Tsrange).DecodeBinary(ci *ConnInfo, src []byte) error func (*Tsrange).DecodeText(ci *ConnInfo, src []byte) error func Tsrange.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Tsrange.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*TsrangeArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*TsrangeArray).DecodeText(ci *ConnInfo, src []byte) error func TsrangeArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TsrangeArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Tstzrange).DecodeBinary(ci *ConnInfo, src []byte) error func (*Tstzrange).DecodeText(ci *ConnInfo, src []byte) error func Tstzrange.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Tstzrange.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*TstzrangeArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*TstzrangeArray).DecodeText(ci *ConnInfo, src []byte) error func TstzrangeArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func TstzrangeArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Unknown).DecodeBinary(ci *ConnInfo, src []byte) error func (*Unknown).DecodeText(ci *ConnInfo, src []byte) error func (*UUID).DecodeBinary(ci *ConnInfo, src []byte) error func (*UUID).DecodeText(ci *ConnInfo, src []byte) error func UUID.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func UUID.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*UUIDArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*UUIDArray).DecodeText(ci *ConnInfo, src []byte) error func UUIDArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func UUIDArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func ValueTranscoder.DecodeBinary(ci *ConnInfo, src []byte) error func ValueTranscoder.DecodeText(ci *ConnInfo, src []byte) error func ValueTranscoder.EncodeBinary(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func ValueTranscoder.EncodeText(ci *ConnInfo, buf []byte) (newBuf []byte, err error) func (*Varbit).DecodeBinary(ci *ConnInfo, src []byte) error func (*Varbit).DecodeText(ci *ConnInfo, src []byte) error func Varbit.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Varbit.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*Varchar).DecodeBinary(ci *ConnInfo, src []byte) error func (*Varchar).DecodeText(ci *ConnInfo, src []byte) error func Varchar.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func Varchar.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*VarcharArray).DecodeBinary(ci *ConnInfo, src []byte) error func (*VarcharArray).DecodeText(ci *ConnInfo, src []byte) error func VarcharArray.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func VarcharArray.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func (*XID).DecodeBinary(ci *ConnInfo, src []byte) error func (*XID).DecodeText(ci *ConnInfo, src []byte) error func XID.EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) func XID.EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) func github.com/jackc/pgx/v4.ScanRow(connInfo *ConnInfo, fieldDescriptions []pgproto3.FieldDescription, values [][]byte, dest ...interface{}) error
Name string OID uint32 Value Value func (*ConnInfo).DataTypeForName(name string) (*DataType, bool) func (*ConnInfo).DataTypeForOID(oid uint32) (*DataType, bool) func (*ConnInfo).DataTypeForValue(v interface{}) (*DataType, bool) func (*ConnInfo).RegisterDataType(t DataType)
InfinityModifier InfinityModifier Status Status Time time.Time (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Date Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Date LowerType BoundType Status Status Upper Date UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []GenericText Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : TextDecoder T : TextEncoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
EnumType represents a enum type. While it implements Value, this is only in service of its type conversion duties when registered as a data type in a ConnType. It should not be used directly as a Value. (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} (*T) Members() []string (*T) NewTypeValue() Value ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Set assigns src to dst. Set purposely does not check that src is a member. This allows continued error free operation in the event the PostgreSQL enum type is modified during a connection. (*T) TypeName() string *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : TypeValue *T : Value *T : ValueTranscoder func NewEnumType(typeName string, members []string) *EnumType
Float float32 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Float4 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Float float64 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Float8 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
GenericBinary is a placeholder for binary format values that no other type exists to handle. Bytes []byte Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
GenericText is a placeholder for text format values that no other type exists to handle. Status Status String string (*T) AssignTo(dst interface{}) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : TextDecoder T : TextEncoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
Hstore represents an hstore column that can be null or have null values associated with its keys. Map map[string]Text Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Hstore Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Inet represents both inet and cidr PostgreSQL types. IPNet *net.IPNet Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error EncodeBinary encodes src into w. ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Inet Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
( T) String() string T : expvar.Var T : fmt.Stringer const Infinity const NegativeInfinity const None
Int int16 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler
Dimensions []ArrayDimension Elements []Int2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Int int32 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Int4 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Int4 LowerType BoundType Status Status Upper Int4 UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Int int64 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Int8 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Int8 LowerType BoundType Status Status Upper Int8 UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Days int32 Microseconds int64 Months int32 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error EncodeBinary encodes src into w. ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Bytes []byte Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Bytes []byte Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []JSONB Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
A float64 B float64 C float64 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
P [2]Vec2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Addr net.HardwareAddr Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error EncodeBinary encodes src into w. ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Macaddr Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Name is a type used for PostgreSQL's special 63-byte name data type, used for identifiers like table names. The pg_class.relname column is a good example of where the name data type is used. Note that the underlying Go data type of pgx.Name is string, so there is no way to enforce the 63-byte length. Inputting a longer name into PostgreSQL will result in silent truncation to 63 bytes. Also, if you have custom-compiled PostgreSQL and set NAMEDATALEN to a different value, obviously that number of bytes applies, rather than the default 63. Status Status String string (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Exp int32 Int *big.Int NaN bool Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Numeric Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Numeric LowerType BoundType Status Status Upper Numeric UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
OID (Object Identifier Type) is, according to https://www.postgresql.org/docs/current/static/datatype-oid.html, used internally by PostgreSQL as a primary key for various system tables. It is currently implemented as an unsigned four-byte integer. Its definition can be found in src/include/postgres_ext.h in the PostgreSQL sources. Because it is so frequently required to be in a NOT NULL condition OID cannot be NULL. To allow for NULL OIDs use OIDValue. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) Scan implements the database/sql Scanner interface. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : database/sql.Scanner T : database/sql/driver.Valuer
OIDValue (Object Identifier Type) is, according to https://www.postgresql.org/docs/current/static/datatype-OIDValue.html, used internally by PostgreSQL as a primary key for various system tables. It is currently implemented as an unsigned four-byte integer. Its definition can be found in src/include/postgres_ext.h in the PostgreSQL sources. Status Status Uint uint32 AssignTo assigns from src to dst. Note that as OIDValue is not a general number type AssignTo does not do automatic type conversion as other number types do. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts from src to dst. Note that as OIDValue is not a general number type Set does not do automatic type conversion as other number types do. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
ParamFormatPreferrer allows a type to specify its preferred param format instead of it being inferred from whether it is also a BinaryEncoder. ( T) PreferredParamFormat() int16 BPChar EnumType JSON JSONB Text Varchar
Closed bool P []Vec2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
P Vec2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(point []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
P []Vec2 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts src to dest. src can be nil, string, []float64, and []pgtype.Vec2. If src is string the format must be ((x1,y1),(x2,y2),...,(xn,yn)). Important that there are no spaces in it. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
QChar is for PostgreSQL's special 8-bit-only "char" type more akin to the C language's char type, or Go's byte type. (Note that the name in PostgreSQL itself is "char", in double-quotes, and not char.) It gets used a lot in PostgreSQL's system tables to hold a single ASCII character value (eg pg_class.relkind). It is named Qchar for quoted char to disambiguate from SQL standard type char. Not all possible values of QChar are representable in the text format. Therefore, QChar does not implement TextEncoder and TextDecoder. In addition, database/sql Scanner and database/sql/driver Value are not implemented. Int int8 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} (*T) Set(src interface{}) error *T : BinaryDecoder T : BinaryEncoder *T : Value
Record is the generic PostgreSQL record type such as is created with the "row" function. Record only implements BinaryEncoder and Value. The text format output format from PostgreSQL does not include type information and is therefore impossible to decode. No encoders are implemented because PostgreSQL does not support input of generic records. Fields []Value Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error ( T) Get() interface{} (*T) Set(src interface{}) error *T : BinaryDecoder *T : Value
ResultFormatPreferrer allows a type to specify its preferred result format instead of it being inferred from whether it is also a BinaryDecoder. ( T) PreferredResultFormat() int16 BPChar EnumType JSON JSONB Text Varchar
ScanPlan is a precompiled plan to scan into a type of destination. Scan scans src into dst. If the dst type has changed in an incompatible way a ScanPlan should automatically replan and scan. func (*ConnInfo).PlanScan(oid uint32, formatCode int16, dst interface{}) ScanPlan
const Null const Present const Undefined
Status Status String string (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Text Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
DecodeText decodes src into TextDecoder. If src is nil then the original SQL value is NULL. TextDecoder takes ownership of src. The caller MUST not use it again. *ACLItem *ACLItemArray *ArrayType *Bit *Bool *BoolArray *Box *BPChar *BPCharArray *Bytea *ByteaArray *CID *CIDR *CIDRArray *Circle CompositeFields *CompositeType *Date *DateArray *Daterange *EnumArray *EnumType *Float4 *Float4Array *Float8 *Float8Array *GenericText *Hstore *HstoreArray *Inet *InetArray *Int2 *Int2Array *Int4 *Int4Array *Int4range *Int8 *Int8Array *Int8range *Interval *JSON *JSONB *JSONBArray *Line *Lseg *Macaddr *MacaddrArray *Name *Numeric *NumericArray *Numrange *OID *OIDValue *Path *Point *Polygon *Text *TextArray *TID *Time *Timestamp *TimestampArray *Timestamptz *TimestamptzArray *Tsrange *TsrangeArray *Tstzrange *TstzrangeArray *Unknown *UUID *UUIDArray ValueTranscoder (interface) *Varbit *Varchar *VarcharArray *XID func (*CompositeTextScanner).ScanDecoder(d TextDecoder)
TextEncoder is implemented by types that can encode themselves into the PostgreSQL text wire format. EncodeText should append the text format of self to buf. If self is the SQL value NULL then append nothing and return (nil, nil). The caller of EncodeText is responsible for writing the correct NULL value or the length of the data written. ACLItem ACLItemArray ArrayType Bit Bool BoolArray Box BPChar BPCharArray Bytea ByteaArray CID CIDR CIDRArray Circle CompositeFields CompositeType Date DateArray Daterange EnumArray EnumType Float4 Float4Array Float8 Float8Array GenericText Hstore HstoreArray Inet InetArray Int2 Int2Array Int4 Int4Array Int4range Int8 Int8Array Int8range Interval JSON JSONB JSONBArray Line Lseg Macaddr MacaddrArray Name Numeric NumericArray Numrange OID OIDValue Path Point Polygon Text TextArray TID Time Timestamp TimestampArray Timestamptz TimestamptzArray Tsrange TsrangeArray Tstzrange TstzrangeArray UUID UUIDArray ValueTranscoder (interface) Varbit Varchar VarcharArray XID func EncodeValueText(src TextEncoder) (interface{}, error) func (*CompositeTextBuilder).AppendEncoder(field TextEncoder)
TID is PostgreSQL's Tuple Identifier type. When one does select ctid, * from some_table; it is the data type of the ctid hidden system column. It is currently implemented as a pair unsigned two byte integers. Its conversion functions can be found in src/backend/utils/adt/tid.c in the PostgreSQL sources. BlockNumber uint32 OffsetNumber uint16 Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Time represents the PostgreSQL time type. The PostgreSQL time is a time of day without time zone. Time is represented as the number of microseconds since midnight in the same way that PostgreSQL does. Other time and date types in pgtype can use time.Time as the underlying representation. However, pgtype.Time type cannot due to needing to handle 24:00:00. time.Time converts that to 00:00:00 on the following day. // Number of microseconds since midnight Status Status (*T) AssignTo(dst interface{}) error DecodeBinary decodes from src into dst. DecodeText decodes from src into dst. EncodeBinary writes the binary encoding of src into w. If src.Time is not in the UTC time zone it returns an error. EncodeText writes the text encoding of src into w. ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts src into a Time and stores in dst. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Timestamp represents the PostgreSQL timestamp type. The PostgreSQL timestamp does not have a time zone. This presents a problem when translating to and from time.Time which requires a time zone. It is highly recommended to use timestamptz whenever possible. Timestamp methods either convert to UTC or return an error on non-UTC times. InfinityModifier InfinityModifier Status Status Time time.Time (*T) AssignTo(dst interface{}) error DecodeBinary decodes from src into dst. The decoded time is considered to be in UTC. DecodeText decodes from src into dst. The decoded time is considered to be in UTC. EncodeBinary writes the binary encoding of src into w. If src.Time is not in the UTC time zone it returns an error. EncodeText writes the text encoding of src into w. If src.Time is not in the UTC time zone it returns an error. ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts src into a Timestamp and stores in dst. If src is a time.Time in a non-UTC time zone, the time zone is discarded. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Timestamp Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
InfinityModifier InfinityModifier Status Status Time time.Time (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Timestamptz Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Timestamp LowerType BoundType Status Status Upper Timestamp UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Tsrange Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower Timestamptz LowerType BoundType Status Status Upper Timestamptz UpperType BoundType (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Dimensions []ArrayDimension Elements []Tstzrange Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
TypeValue is a Value where instances can represent different PostgreSQL types. This can be useful for representing types such as enums, composites, and arrays. In general, instances of TypeValue should not be used to directly represent a value. It should only be used as an encoder and decoder internal to ConnInfo. AssignTo converts and assigns the Value to dst. AssignTo may a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. Get returns the simplest representation of Value. Get may return a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. NewTypeValue creates a TypeValue including references to internal type information. e.g. the list of members in an EnumType. Set converts and assigns src to itself. Value takes ownership of src. TypeName returns the PostgreSQL name of this type. *ArrayType *CompositeType *EnumType T : Value
Unknown represents the PostgreSQL unknown type. It is either a string literal or NULL. It is used when PostgreSQL does not know the type of a value. In general, this will only be used in pgx when selecting a null value without type information. e.g. SELECT NULL; Status Status String string AssignTo assigns from src to dst. Note that as Unknown is not a general number type AssignTo does not do automatic type conversion as other number types do. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder *T : TextDecoder *T : Value *T : database/sql.Scanner T : database/sql/driver.Valuer
Lower []byte LowerType BoundType Upper []byte UpperType BoundType func ParseUntypedBinaryRange(src []byte) (*UntypedBinaryRange, error)
Dimensions []ArrayDimension Elements []string Quoted []bool func ParseUntypedTextArray(src string) (*UntypedTextArray, error)
Lower string LowerType BoundType Upper string UpperType BoundType func ParseUntypedTextRange(src string) (*UntypedTextRange, error)
Bytes [16]byte Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error (*T) UnmarshalJSON(src []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []UUID Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Value translates values to and from an internal canonical representation for the type. To actually be usable a type that implements Value should also implement some combination of BinaryDecoder, BinaryEncoder, TextDecoder, and TextEncoder. Operations that update a Value (e.g. Set, DecodeText, DecodeBinary) should entirely replace the value. e.g. Internal slices should be replaced not resized and reused. This allows Get and AssignTo to return a slice directly rather than incur a usually unnecessary copy. AssignTo converts and assigns the Value to dst. AssignTo may a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. Get returns the simplest representation of Value. Get may return a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. Set converts and assigns src to itself. Value takes ownership of src. *ACLItem *ACLItemArray *ArrayType *Bit *Bool *BoolArray *Box *BPChar *BPCharArray *Bytea *ByteaArray *CID *CIDR *CIDRArray *Circle *CompositeType *Date *DateArray *Daterange *EnumArray *EnumType *Float4 *Float4Array *Float8 *Float8Array *GenericBinary *GenericText *Hstore *HstoreArray *Inet *InetArray *Int2 *Int2Array *Int4 *Int4Array *Int4range *Int8 *Int8Array *Int8range *Interval *JSON *JSONB *JSONBArray *Line *Lseg *Macaddr *MacaddrArray *Name *Numeric *NumericArray *Numrange *OIDValue *Path *Point *Polygon *QChar *Record *Text *TextArray *TID *Time *Timestamp *TimestampArray *Timestamptz *TimestamptzArray *Tsrange *TsrangeArray *Tstzrange *TstzrangeArray TypeValue (interface) *Unknown *UUID *UUIDArray ValueTranscoder (interface) *Varbit *Varchar *VarcharArray *XID func NewValue(v Value) Value func (*ArrayType).NewTypeValue() Value func (*CompositeType).NewTypeValue() Value func (*EnumType).NewTypeValue() Value func TypeValue.NewTypeValue() Value func DatabaseSQLValue(ci *ConnInfo, src Value) (interface{}, error) func NewValue(v Value) Value
ValueTranscoder is a value that implements the text and binary encoding and decoding interfaces. AssignTo converts and assigns the Value to dst. AssignTo may a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. DecodeBinary decodes src into BinaryDecoder. If src is nil then the original SQL value is NULL. BinaryDecoder takes ownership of src. The caller MUST not use it again. DecodeText decodes src into TextDecoder. If src is nil then the original SQL value is NULL. TextDecoder takes ownership of src. The caller MUST not use it again. EncodeBinary should append the binary format of self to buf. If self is the SQL value NULL then append nothing and return (nil, nil). The caller of EncodeBinary is responsible for writing the correct NULL value or the length of the data written. EncodeText should append the text format of self to buf. If self is the SQL value NULL then append nothing and return (nil, nil). The caller of EncodeText is responsible for writing the correct NULL value or the length of the data written. Get returns the simplest representation of Value. Get may return a pointer to an internal value but it must never mutate that value. e.g. If Get returns a []byte Value must never change the contents of the []byte. Set converts and assigns src to itself. Value takes ownership of src. *ArrayType *Bit *Bool *BoolArray *Box *BPChar *BPCharArray *Bytea *ByteaArray *CID *CIDR *CIDRArray *Circle *CompositeType *Date *DateArray *Daterange *EnumType *Float4 *Float4Array *Float8 *Float8Array *Hstore *HstoreArray *Inet *InetArray *Int2 *Int2Array *Int4 *Int4Array *Int4range *Int8 *Int8Array *Int8range *Interval *JSON *JSONB *JSONBArray *Line *Lseg *Macaddr *MacaddrArray *Name *Numeric *NumericArray *Numrange *OIDValue *Path *Point *Polygon *Text *TextArray *TID *Time *Timestamp *TimestampArray *Timestamptz *TimestamptzArray *Tsrange *TsrangeArray *Tstzrange *TstzrangeArray *UUID *UUIDArray *Varbit *Varchar *VarcharArray *XID T : BinaryDecoder T : BinaryEncoder T : TextDecoder T : TextEncoder T : Value func NewCompositeTypeValues(typeName string, fields []CompositeTypeField, values []ValueTranscoder) (*CompositeType, error)
Bytes []byte // Number of bits Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Status Status String string AssignTo assigns from src to dst. Note that as Varchar is not a general number type AssignTo does not do automatic type conversion as other number types do. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} ( T) MarshalJSON() ([]byte, error) ( T) PreferredParamFormat() int16 ( T) PreferredResultFormat() int16 Scan implements the database/sql Scanner interface. Set converts from src to dst. Note that as Varchar is not a general number type Set does not do automatic type conversion as other number types do. (*T) UnmarshalJSON(b []byte) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder T : ParamFormatPreferrer T : ResultFormatPreferrer *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer T : encoding/json.Marshaler *T : encoding/json.Unmarshaler
Dimensions []ArrayDimension Elements []Varchar Status Status (*T) AssignTo(dst interface{}) error (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. (*T) Set(src interface{}) error Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
X float64 Y float64
XID is PostgreSQL's Transaction ID type. In later versions of PostgreSQL, it is the type used for the backend_xid and backend_xmin columns of the pg_stat_activity system view. Also, when one does select xmin, xmax, * from some_table; it is the data type of the xmin and xmax hidden system columns. It is currently implemented as an unsigned four byte integer. Its definition can be found in src/include/postgres_ext.h as TransactionId in the PostgreSQL sources. Status Status Uint uint32 AssignTo assigns from src to dst. Note that as XID is not a general number type AssignTo does not do automatic type conversion as other number types do. (*T) DecodeBinary(ci *ConnInfo, src []byte) error (*T) DecodeText(ci *ConnInfo, src []byte) error ( T) EncodeBinary(ci *ConnInfo, buf []byte) ([]byte, error) ( T) EncodeText(ci *ConnInfo, buf []byte) ([]byte, error) ( T) Get() interface{} Scan implements the database/sql Scanner interface. Set converts from src to dst. Note that as XID is not a general number type Set does not do automatic type conversion as other number types do. Value implements the database/sql/driver Valuer interface. *T : BinaryDecoder T : BinaryEncoder *T : TextDecoder T : TextEncoder *T : Value *T : ValueTranscoder *T : database/sql.Scanner T : database/sql/driver.Valuer
Package-Level Functions (total 57, in which 19 are exported)
func DatabaseSQLValue(ci *ConnInfo, src Value) (interface{}, error)
func EncodeValueText(src TextEncoder) (interface{}, error)
GetAssignToDstType attempts to convert dst to something AssignTo can assign to. If dst is a pointer to pointer it allocates a value and returns the dereferences pointer. If dst is a named type such as *Foo where Foo is type Foo int16, it converts dst to *int16. GetAssignToDstType returns the converted dst and a bool representing if any change was made.
func NewArrayType(typeName string, elementOID uint32, newElement func() ValueTranscoder) *ArrayType
NewCompositeBinaryScanner a scanner over a binary encoded composite balue.
NewCompositeTextScanner a scanner over a text encoded composite value.
NewCompositeType creates a CompositeType from fields and ci. ci is used to find the ValueTranscoders used for fields. All field OIDs must be previously registered in ci.
NewCompositeTypeValues creates a CompositeType from fields and values. fields and values must have the same length. Prefer NewCompositeType unless overriding the transcoding of fields is required.
NewEnumType initializes a new EnumType. It retains a read-only reference to members. members must not be changed.
NewValue returns a new instance of the same type as v.
func NullAssignTo(dst interface{}) error
Package-Level Constants (total 112, in which 79 are exported)
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL format codes
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL format codes
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types
PostgreSQL oids for common types