Types By Category
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:
Check out pg_type
in the Postgres docs for a list of all categories and codes.
Last updated