Re: Selecting user-defined CASTs

On 08/09/2011 01:27 AM, Tom Lane wrote:
> Another approach is to check pg_depend.  A cast installed by initdb will
> match a "pin" entry in pg_depend (refclassid = pg_cast, refobjid =
> cast's OID, deptype = 'p').  You're still out of luck for distinguishing
> extension members in existing releases, but in 9.1 and up it'll be
> possible to identify casts belonging to extensions from pg_depend
> entries.

Intriguing alternative.

The query is for my dbtoyaml utility which is sort of equivalent to
pg_dump -s --format=y (yaml). So for now, I'll stick to emulating what
dumpCast in pg_dump.c does.

Joe