Larry Rosenman <ler(at)lerctr(dot)org> writes:
>> Actually, I think you can do it with CREATE CAST.
> The issue (for me) was decoding the function name(s).
I find the 7.3 OID-alias types very helpful for this sort of thing:
regression=# select castsource::regtype, casttarget::regtype, castfunc::regprocedure, castcontext from pg_cast limit 1;
castsource | casttarget | castfunc | castcontext
------------+------------+--------------+-------------
bigint | smallint | int2(bigint) | a
(1 row)
> I wish there was a \ command to display pg_cast...
There is (\dC). But it's not very bright --- I don't think you can
limit the rows displayed at all.
regards, tom lane