Skip to content

Instantly share code, notes, and snippets.

@hooopo
Created April 15, 2020 04:17
Show Gist options
  • Save hooopo/e84f87cfd0c67bc124d110e61116cd27 to your computer and use it in GitHub Desktop.
Save hooopo/e84f87cfd0c67bc124d110e61116cd27 to your computer and use it in GitHub Desktop.
data_type | udt_name
-----------------------------+-----------
ARRAY | _float8
ARRAY | _int4
ARRAY | _int8
ARRAY | _numeric
ARRAY | _text
ARRAY | _varchar
bigint | int8
boolean | bool
bytea | bytea
character varying | varchar
date | date
double precision | float8
integer | int4
jsonb | jsonb
numeric | numeric
oid | oid
text | text
timestamp without time zone | timestamp
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment