[postgis-users] php query problem "AsText(table.geometry)", multiple schemas

Stephen Woodbridge woodbri at swoodbridge.com
Thu Apr 13 14:08:29 PDT 2006


You can set it in pgAdmin III look in the "Login Roles" and add it to 
the "variables"

or via psql with something like:

ALTER ROLE <user> SET search_path=<schema1>, <schema2>, public;


Andreas Neumann wrote:
> Stephen Woodbridge wrote:
>> Andreas,
>> Do you use different users when connecting from the different clients? 
>> If you do then you probably need to change the search_path for the 
>> PHP5 client to include the public schema. It is also possible that 
>> PHP5 is resetting the search_path but this is likely to be the root of 
>> the problem.
> yes, indeed, I use different users. The user php uses has limited rights 
> (select only). Do you have an example on how to set the "search_path" in 
> php? Or is this done within postgresql?
> That way I wouldn't have to add the schema name before the function name 
> and just use the normal SQL statements.
> Thank you very much for that hint and any further information on how to 
> set the search_path.
> Andreas

More information about the postgis-users mailing list