Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgres_pgtype

package

Go to main page

Versions in this module

v1

v1.0.247

Dec 18, 2025

v1.0.246

Dec 17, 2025

v1.0.245

Dec 17, 2025

v1.0.244

Dec 17, 2025

v1.0.243

Dec 17, 2025

v1.0.242

Dec 17, 2025

v1.0.241

Dec 17, 2025

v1.0.240

Dec 17, 2025

v1.0.239

Dec 17, 2025

v1.0.238

Dec 17, 2025

v1.0.237

Dec 17, 2025

v1.0.236

Dec 17, 2025

v1.0.235

Dec 17, 2025

v1.0.234

Dec 16, 2025

v1.0.233

Dec 16, 2025

v1.0.232

Nov 17, 2025

v1.0.231

Nov 11, 2025

v1.0.230

Nov 5, 2025

v1.0.229

Nov 5, 2025

v1.0.228

Nov 5, 2025

v1.0.227

Nov 5, 2025

v1.0.226

Oct 14, 2025

v1.0.225

Oct 6, 2025

v1.0.224

Oct 1, 2025

v1.0.223

Sep 16, 2025

v1.0.222

Sep 16, 2025

v1.0.221

Sep 16, 2025

v1.0.220

Sep 15, 2025

v1.0.219

Sep 3, 2025

v1.0.218

Sep 2, 2025

v1.0.217

Aug 18, 2025

v1.0.216

Aug 18, 2025

v1.0.215

Aug 13, 2025

v1.0.214

Aug 12, 2025

v1.0.213

Aug 12, 2025

v1.0.212

Aug 12, 2025

v1.0.211

Aug 12, 2025

v1.0.210

Jul 7, 2025

v1.0.209

Jul 7, 2025

v1.0.208

Jul 7, 2025

v1.0.207

Jul 3, 2025

v1.0.206

Jul 3, 2025

v1.0.205

Jul 3, 2025

Changes in this version

+ type TimeScanner interface

+ ScanTime func(v Time) error

v1.0.204

Jul 3, 2025

v1.0.203

Jul 2, 2025

Changes in this version

+ const ACLItemArrayOID

+ const ACLItemOID

+ const BPCharArrayOID

+ const BPCharOID

+ const BitArrayOID

+ const BitOID

+ const BoolArrayOID

+ const BoolOID

+ const BoxArrayOID

+ const BoxOID

+ const ByteaArrayOID

+ const ByteaOID

+ const CIDArrayOID

+ const CIDOID

+ const CIDRArrayOID

+ const CIDROID

+ const CircleArrayOID

+ const CircleOID

+ const DateArrayOID

+ const DateOID

+ const DatemultirangeArrayOID

+ const DatemultirangeOID

+ const DaterangeArrayOID

+ const DaterangeOID

+ const Float4ArrayOID

+ const Float4OID

+ const Float8ArrayOID

+ const Float8OID

+ const InetArrayOID

+ const InetOID

+ const Int2ArrayOID

+ const Int2OID

+ const Int4ArrayOID

+ const Int4OID

+ const Int4multirangeArrayOID

+ const Int4multirangeOID

+ const Int4rangeArrayOID

+ const Int4rangeOID

+ const Int8ArrayOID

+ const Int8OID

+ const Int8multirangeArrayOID

+ const Int8multirangeOID

+ const Int8rangeArrayOID

+ const Int8rangeOID

+ const IntervalArrayOID

+ const IntervalOID

+ const JSONArrayOID

+ const JSONBArrayOID

+ const JSONBOID

+ const JSONOID

+ const JSONPathArrayOID

+ const JSONPathOID

+ const LineArrayOID

+ const LineOID

+ const LsegArrayOID

+ const LsegOID

+ const Macaddr8OID

+ const MacaddrArrayOID

+ const MacaddrOID

+ const NameArrayOID

+ const NameOID

+ const NumericArrayOID

+ const NumericOID

+ const NummultirangeArrayOID

+ const NummultirangeOID

+ const NumrangeArrayOID

+ const NumrangeOID

+ const OIDArrayOID

+ const OIDOID

+ const PathArrayOID

+ const PathOID

+ const PointArrayOID

+ const PointOID

+ const PolygonArrayOID

+ const PolygonOID

+ const QCharArrayOID

+ const QCharOID

+ const RecordArrayOID

+ const RecordOID

+ const TIDArrayOID

+ const TIDOID

+ const TextArrayOID

+ const TextOID

+ const TimeArrayOID

+ const TimeOID

+ const TimestampArrayOID

+ const TimestampOID

+ const TimestamptzArrayOID

+ const TimestamptzOID

+ const TimetzArrayOID

+ const TimetzOID

+ const TsmultirangeArrayOID

+ const TsmultirangeOID

+ const TsrangeArrayOID

+ const TsrangeOID

+ const TstzmultirangeArrayOID

+ const TstzmultirangeOID

+ const TstzrangeArrayOID

+ const TstzrangeOID

+ const UUIDArrayOID

+ const UUIDOID

+ const UnknownOID

+ const VarbitArrayOID

+ const VarbitOID

+ const VarcharArrayOID

+ const VarcharOID

+ const XID8ArrayOID

+ const XID8OID

+ const XIDArrayOID

+ const XIDOID

+ const XMLArrayOID

+ const XMLOID

+ func AppendInt16(buf []byte, n int16) []byte

+ func AppendInt32(buf []byte, n int32) []byte

+ func AppendInt64(buf []byte, n int64) []byte

+ func AppendUint16(buf []byte, n uint16) []byte

+ func AppendUint32(buf []byte, n uint32) []byte

+ func AppendUint64(buf []byte, n uint64) []byte

+ func SetInt32(buf []byte, n int32)

+ type Date struct

+ InfinityModifier pgtype.InfinityModifier

+ Time time.Time

+ Valid bool

+ func (d *Date) ScanDate(v Date) error

+ func (d Date) DateValue() (Date, error)

+ func (dst *Date) Scan(src any) error

+ func (dst *Date) UnmarshalJSON(b []byte) error

+ func (src Date) MarshalJSON() ([]byte, error)

+ func (src Date) Value() (driver.Value, error)

+ type DateCodec struct

+ func (DateCodec) FormatSupported(format int16) bool

+ func (DateCodec) PlanEncode(m *pgtype.Map, oid uint32, format int16, value any) pgtype.EncodePlan

+ func (DateCodec) PlanScan(m *pgtype.Map, oid uint32, format int16, target any) pgtype.ScanPlan

+ func (DateCodec) PreferredFormat() int16

+ func (c DateCodec) DecodeDatabaseSQLValue(m *pgtype.Map, oid uint32, format int16, src []byte) (driver.Value, error)

+ func (c DateCodec) DecodeValue(m *pgtype.Map, oid uint32, format int16, src []byte) (any, error)

+ type Interval struct

+ Days int32

+ Microseconds int64

+ Months int32

+ Valid bool

+ func (interval *Interval) Scan(src any) error

+ func (interval *Interval) ScanInterval(v Interval) error

+ func (interval Interval) IntervalValue() (Interval, error)

+ func (interval Interval) Value() (driver.Value, error)

+ type IntervalCodec struct

+ func (IntervalCodec) FormatSupported(format int16) bool

+ func (IntervalCodec) PlanEncode(m *pgtype.Map, oid uint32, format int16, value any) pgtype.EncodePlan

+ func (IntervalCodec) PlanScan(m *pgtype.Map, oid uint32, format int16, target any) pgtype.ScanPlan

+ func (IntervalCodec) PreferredFormat() int16

+ func (c IntervalCodec) DecodeDatabaseSQLValue(m *pgtype.Map, oid uint32, format int16, src []byte) (driver.Value, error)

+ func (c IntervalCodec) DecodeValue(m *pgtype.Map, oid uint32, format int16, src []byte) (any, error)

+ type IntervalScanner interface

+ ScanInterval func(v Interval) error

+ type IntervalValuer interface

+ IntervalValue func() (Interval, error)

+ type Time struct

+ Microseconds int64

+ Valid bool

+ func (t *Time) Scan(src any) error

+ func (t *Time) ScanTime(v Time) error

+ func (t Time) TimeValue() (Time, error)

+ func (t Time) Value() (driver.Value, error)

+ type TimeCodec struct

+ func (TimeCodec) FormatSupported(format int16) bool

+ func (TimeCodec) PlanEncode(m *pgtype.Map, oid uint32, format int16, value any) pgtype.EncodePlan

+ func (TimeCodec) PlanScan(m *pgtype.Map, oid uint32, format int16, target any) pgtype.ScanPlan

+ func (TimeCodec) PreferredFormat() int16

+ func (c TimeCodec) DecodeDatabaseSQLValue(m *pgtype.Map, oid uint32, format int16, src []byte) (driver.Value, error)

+ func (c TimeCodec) DecodeValue(m *pgtype.Map, oid uint32, format int16, src []byte) (any, error)

+ type Timestamp struct

+ InfinityModifier pgtype.InfinityModifier

+ Time time.Time

+ Valid bool

+ func (ts *Timestamp) Scan(src any) error

+ func (ts *Timestamp) ScanTimestamp(v Timestamp) error

+ func (ts *Timestamp) UnmarshalJSON(b []byte) error

+ func (ts Timestamp) MarshalJSON() ([]byte, error)

+ func (ts Timestamp) TimestampValue() (Timestamp, error)

+ func (ts Timestamp) Value() (driver.Value, error)

+ type TimestampCodec struct

+ ScanLocation *time.Location

+ func (*TimestampCodec) FormatSupported(format int16) bool

+ func (*TimestampCodec) PlanEncode(m *pgtype.Map, oid uint32, format int16, value any) pgtype.EncodePlan

+ func (*TimestampCodec) PreferredFormat() int16

+ func (c *TimestampCodec) DecodeDatabaseSQLValue(m *pgtype.Map, oid uint32, format int16, src []byte) (driver.Value, error)

+ func (c *TimestampCodec) DecodeValue(m *pgtype.Map, oid uint32, format int16, src []byte) (any, error)

+ func (c *TimestampCodec) PlanScan(m *pgtype.Map, oid uint32, format int16, target any) pgtype.ScanPlan

+ type Timestamptz struct

+ InfinityModifier pgtype.InfinityModifier

+ Time time.Time

+ Valid bool

+ func (tstz *Timestamptz) Scan(src any) error

+ func (tstz *Timestamptz) ScanTimestamptz(v Timestamptz) error

+ func (tstz *Timestamptz) UnmarshalJSON(b []byte) error

+ func (tstz Timestamptz) MarshalJSON() ([]byte, error)

+ func (tstz Timestamptz) TimestamptzValue() (Timestamptz, error)

+ func (tstz Timestamptz) Value() (driver.Value, error)

+ type TimestamptzCodec struct

+ ScanLocation *time.Location

+ func (*TimestamptzCodec) FormatSupported(format int16) bool

+ func (*TimestamptzCodec) PlanEncode(m *pgtype.Map, oid uint32, format int16, value any) pgtype.EncodePlan

+ func (*TimestamptzCodec) PreferredFormat() int16

+ func (c *TimestamptzCodec) DecodeDatabaseSQLValue(m *pgtype.Map, oid uint32, format int16, src []byte) (driver.Value, error)

+ func (c *TimestamptzCodec) DecodeValue(m *pgtype.Map, oid uint32, format int16, src []byte) (any, error)

+ func (c *TimestamptzCodec) PlanScan(m *pgtype.Map, oid uint32, format int16, target any) pgtype.ScanPlan