我正在更新我的自定义postgresql类型,我需要在函数中找到我使用/返回的类型。我该怎么做?非常感谢。
类型:
-- Type: public.dblchk_picked_qty
-- DROP TYPE public.dblchk_picked_qty;
CREATE TYPE public.dblchk_picked_qty AS
("number" text,
eancode text,
packageean text,
name text,
pickingunit text,
basicunitsinbox numeric,
containerid integer,
ownersordernumber text,
customerref text);
ALTER TYPE public.dblchk_picked_qty
OWNER TO nordnet;
好的,我已经解决了,
获取类型oid:
SELECT reltype
FROM pg_class
WHERE relname = 'dblchk_picked_qty'
按类型id:在函数中查找返回类型
SELECT proname
FROM pg_proc
WHERE prorettype = 17543