(TIL) PSQL: Types By Category

less than 1 minute read

Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of these categories has a corresponding code. For instance, numeric types have a code of N. Using N I can get a list of all the numeric types:

> select typname from pg_type where typcategory = 'N';
     typname
-----------------
 int8
 int2
 int4
 regproc
 oid
 float4
 float8
 money
 numeric
 regprocedure
 regoper
 regoperator
 regclass
 regtype
 regconfig
 regdictionary
 cardinal_number
(17 rows)

Check out pg_type in the Postgres docs for a list of all categories and codes.

Via jbranchaud/til.

Comments