default postgreSQL schema
| From: | Alain Roger | Date: | Mon, 20 Nov 2006 19:02:57 +0000 |
| Subject: | default postgreSQL schema | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-244891@lists.php.net to get a copy of this message | ||
Hi,
I would like to know if under PHP i can setup the default schema for a
PostgreSQL database ?
e.g if my database name is 'mydb', my schema 'immense', i would like to
avoid :
immense.my_function_name(parameter1, parameter2,..)
...
select * from immense.table1 WHERE immense.table1.field1 =
immense.table2.field5;
...
thanks a lot,
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5