Alain Roger wrote:
Hi, is there a way with PDO class to not have: - to execute a simple SET search_path TO myschema;
can you alter the postgres users path? alter user <username> set search_path to new_schema, current_schemas(); or some variation on that.
- and after to fletch another SQL request, like select to be sure that the SQL statement will be perform on this schema ? (basically i want to do it in 1 step)
You can't. After you connect you have to change the schema. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php