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