Re: pdo and dabase schema

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/