# pg_type

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: pg_type
latest-operator-version: v26.2.1
latest-console-tag: v3.10.0
latest-connect-version: 4.104.0
latest-redpanda-tag: v26.2.1
docname: sql/system-catalogs/catalogs/pg_type
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_type.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_type.adoc
description: The pg_type table stores information about built-in data types.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_type.md -->

The `pg_type` table stores information about built-in data types. It mimics the [pg\_type](https://www.postgresql.org/docs/current/catalog-pg-type.html) PostgreSQL system catalog.

> ⚠️ **WARNING**
>
> Redpanda SQL does not support custom types.

## [](#columns)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)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.

```sql
SELECT oid, typname FROM pg_type;
```

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

```sql
 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)
```