DataType

The descriptor shape used to register a codec for a PostgreSQL type on a DataTypeMap — every built-in type on GlobalTypeMap is one of these, and registering a custom type (or overriding a built-in one) means providing an object matching this interface.

Key	Type	Default	Description
oid	OID		PostgreSQL type OID this descriptor decodes/encodes
name	string		Type name (informational, shown in FieldInfo.dataTypeName)
elementsOID	OID		For an array type, the OID of its element type (e.g. the _int4 array type points at int4)
isArray	boolean		Whether this descriptor represents an array type
jsType	string		Name of the JS type values decode to (informational, shown in FieldInfo.jsType)
arraySeparator	string	,	Separator used between elements when encoding this type's text-format array literal
isType	(v: any) => boolean		Predicate used by DataTypeMap.determine() to guess whether a plain JS value should be sent as this type
decodeBinary	DecodeBinaryFunction		Decodes a value from the binary wire format
decodeText	DecodeTextFunction		Decodes a value from the text wire format
decodeTextBuffer	DecodeTextBufferFunction		Optional fast path: decodes directly from the raw wire Buffer instead of the pre-converted UTF-8 string decodeText receives. Only meaningful for text-format scalar columns
fixedBinarySize	number		Declares this type's binary representation as always exactly N bytes (e.g. int4 is always 4). Leave unset for types whose binary length varies by value (bytea, varchar, json, numeric)
encodeAsNull	EncodeAsNullFunction		Predicate deciding whether a given value should be encoded as SQL NULL
encodeBinary	EncodeBinaryFunction		Encodes a value into the binary wire format
encodeText	EncodeTextFunction		Encodes a value into the text wire format
encodeCalculateDim	EncodeCalculateDimFunction		For array types, computes the array's dimensions before encoding

Registering a custom type

import { DataTypeMap, GlobalTypeMap, type DataType } from 'postgrejs';

const myType: DataType = {
  oid: 90210,
  name: 'my_type',
  jsType: 'string',
  isType: v => typeof v === 'string' && v.startsWith('my:'),
  decodeText: v => v,
  decodeBinary: v => v.toString('utf8'),
};

const myTypeMap = new DataTypeMap(GlobalTypeMap);
myTypeMap.register(myType);

See DataTypeMap and the Data Types & Type Mapping guide.