[postgis-users] php query problem "AsText(table.geometry)", multiple schemas
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
or via psql with something like:
ALTER ROLE <user> SET search_path=<schema1>, <schema2>, public;
Andreas Neumann wrote:
> Stephen Woodbridge wrote:
>> 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.
More information about the postgis-users