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"<77287...@qq.com>; 抄送: "pgsql-general"; 主题: Re: [GENERAL] How to make the user-defined function or type beingaccessed in the global database server? On 02/20/2011 09:57 AM, 页公倒龙 wrote: > 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