Skip to content

Instantly share code, notes, and snippets.

@C-Saunders

C-Saunders/query.sql

Created August 1, 2023 14:28
Show Gist options
  • Save C-Saunders/d1a00641f149d1a65d6f9f24923ecc1e to your computer and use it in GitHub Desktop.
Save C-Saunders/d1a00641f149d1a65d6f9f24923ecc1e to your computer and use it in GitHub Desktop.
Download ZIP
Postgres type cast map
Raw
query.sql
select s.typname as source, t.typname as target, castcontext, castmethod
from pg_cast
left join pg_type as s on castsource = s.oid
left join pg_type as t on casttarget = t.oid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment