Cloud

pg_type

The pg_type table stores information about built-in data types. It mimics the pg_type PostgreSQL system catalog.

Redpanda SQL does not support custom types.

Columns

The following columns are available for querying in pg_type:

Column Type Description

oid

int

This column represents the Object ID (OID) for each type in the database

typname

text

This column represents the data type.

typlen

int

This column represents the number of bytes in the internal representation of the type

typnamespace

int

Unused

typowner

int

Unused

typtype

text

Unused

typisdefined

bool

Unused

typstorage

text

Unused

typalign

text

Unused

typnotnull

bool

Unused

typcategory

text

Unused

typispreferred

bool

Unused

typdelim

text

Unused

typrelid

int

Unused

typsubscript

int

Unused

typelem

int

Unused

typarray

int

Unused

typinput

int

Unused

typoutput

int

Unused

typreceive

int

Unused

typsend

int

Unused

typmodin

int

Unused

typmodout

int

Unused

typanalyze

int

Unused

typalign

text

Unused

typstorage

text

Unused

typnotnull

bool

Unused

typbasetype

int

Unused

typtypmod

int

Unused

typndims

int

Unused

typcollation

int

Unused

typdefaultbin

text

Unused

typdefault

text

Unused

typacl

text

Unused

Examples

This example query retrieves the Object ID (oid) and data type name (typname) from the pg_type catalog. You can adjust the columns in the SELECT statement based on your needs.

SELECT oid, typname FROM pg_type;

This returns the list of Redpanda SQL’s supported data types:

 oid  |   typname
------+-------------
   23 | int4
  700 | float4
   16 | bool
   20 | int8
  701 | float8
   25 | text
 1114 | timestamp
 1184 | timestamptz
 1083 | time
 1186 | interval
 1082 | date
  114 | json
(12 rows)