Thanks for your replying. But actually there are some difference database now, and I really want to define the user-defined function or type one time so that they can be accessed as system-defined function or type, how can I do? Thanks!
------------------
祝好!
郭逸重
------------------ 原始邮件 ------------------
发件人: "Craig Ringer";
发送时间: 2011年2月20日(星期天) 中午12:40
收件人: "77287991"<77287991@xxxxxx>;
抄送: "pgsql-general";
主题: Re: [GENERAL] How to make the user-defined function or type beingaccessed in the global database server?
> hello, i had defined user-defined function and type in database A by
> using user Root.when i want to access the function and type in another
> database B by using the same user Root, but found that i could't access
> them. How to make the user-defined function or type being accessed in
> the global database server?
You probably want to use one database with multiple schema instead. See
the manual for more information about schema.
--
Craig Ringer