postgres

const (
	TypeBit     = "bit"
	TypeBitVar  = "bit varying"
	TypeBoolean = "boolean"
	TypeBool    = "bool" // boolean.
	TypeBytea   = "bytea"

	TypeCharacter = "character"
	TypeChar      = "char" // character
	TypeCharVar   = "character varying"
	TypeVarChar   = "varchar" // character varying
	TypeText      = "text"

	TypeSmallInt = "smallint"
	TypeInteger  = "integer"
	TypeBigInt   = "bigint"
	TypeInt      = "int"  // integer.
	TypeInt2     = "int2" // smallint.
	TypeInt4     = "int4" // integer.
	TypeInt8     = "int8" // bigint.

	TypeCIDR     = "cidr"
	TypeInet     = "inet"
	TypeMACAddr  = "macaddr"
	TypeMACAddr8 = "macaddr8"

	TypeCircle     = "circle"
	TypeLine       = "line"
	TypeLseg       = "lseg"
	TypeBox        = "box"
	TypePath       = "path"
	TypePolygon    = "polygon"
	TypePoint      = "point"
	TypePgLSN      = "pg_lsn"
	TypePgSnapshot = "pg_snapshot"
	TypeTSQuery    = "tsquery"
	TypeTSVector   = "tsvector"

	TypeDate               = "date"
	TypeTime               = "time" // time without time zone
	TypeTimeWithTZ         = "time with time zone"
	TypeTimeWithoutTZ      = "time without time zone"
	TypeTimestamp          = "timestamp" // timestamp without time zone
	TypeTimestampTZ        = "timestamptz"
	TypeTimestampWithTZ    = "timestamp with time zone"
	TypeTimestampWithoutTZ = "timestamp without time zone"

	TypeDouble = "double precision"
	TypeReal   = "real"
	TypeFloat8 = "float8" // double precision
	TypeFloat4 = "float4" // real

	TypeNumeric = "numeric"
	TypeDecimal = "decimal" // numeric

	TypeSmallSerial = "smallserial" // smallint with auto_increment.
	TypeSerial      = "serial"      // integer with auto_increment.
	TypeBigSerial   = "bigserial"   // bigint with auto_increment.
	TypeSerial2     = "serial2"     // smallserial
	TypeSerial4     = "serial4"     // serial
	TypeSerial8     = "serial8"     // bigserial

	TypeArray       = "array"
	TypeXML         = "xml"
	TypeJSON        = "json"
	TypeJSONB       = "jsonb"
	TypeUUID        = "uuid"
	TypeMoney       = "money"
	TypeInterval    = "interval"
	TypeUserDefined = "user-defined"
)