set the default schema

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: set the default schema
Date: 2006-11-20 18:59:17
Message-ID: 75645bbb0611201059q2e9d5eacl8f823d98d0e0288e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I do not own my database. in fact, it is stored on my web hoster server.
therefore i would like to know how can i setup the default SCHEMA in order
to no have to write in all my functions, queries or procedures, the
following thing :

schema_name.function_name(parameters,...)

e.g : if my schema is named 'immense' and my function is named 'sp001'

immense.sp001(parameter1, parameter2)
...

thanks a lot

Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ALBER 2006-11-20 19:05:46 error server connection
Previous Message Stephen Harris 2006-11-20 16:53:12 Re: [GENERAL] Shutting down a warm standby database in 8.2beta3