[Sqlrelay-discussion] postgresql, schema and search_path
Brought to you by:
mused
|
From: Thomas P. <tp...@se...> - 2006-10-02 12:17:13
|
Hello, I'm using sqlrelay 0.37 with postgresql 8.0. I have a user who searches to a specific schema : ALTER USER test_user SET search_path TO test, public; With a direct PHP connection or with psql, if I do "select * from months;" I get the test.months column. But with sqlrelay, it searches the public.months column. How can I specify the default schema (without prefixing each request with "test.") ? TIA. -- Thomas Poindessous |