回复: [GENERAL] How to make the user-defined function or type beingaccessed in the global database server? - Mailing list pgsql-general

From 页公倒龙
Subject 回复: [GENERAL] How to make the user-defined function or type beingaccessed in the global database server?
Date
Msg-id tencent_1514F714577EE36438463957@qq.com
Whole thread Raw
Responses Re: »Ø¸´£º [GENERAL] How to make the user-defined function or type beingaccessed in the global database server?
Re: »Ø¸´£º [GENERAL] How to make the user-defined function or type beingaccessed in the global database server?
List pgsql-general
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@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

pgsql-general by date:

Previous
From: matty jones
Date:
Subject: multiple tables as a foreign key
Next
From: Sachin Srivastava
Date:
Subject: Re: password