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