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

From: 页公倒龙 <77287991(at)qq(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: 回复: [GENERAL] How to make the user-defined function or type beingaccessed in the global database server?
Date: 2011-02-20 06:13:51
Message-ID: tencent_1514F714577EE36438463957@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)qq(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2011-02-20 10:51:57 Re: Building extensions on Windows using VS2008
Previous Message Craig Ringer 2011-02-20 04:40:35 Re: How to make the user-defined function or type being accessed in the global database server?