set persistent search_path

Поиск
Список
Период
Сортировка
Искать

set persistent search_path

От:
Pedro Salazar <pedro-b-salazar@ptinovacao.pt>
Дата:
Greetings,

I created a user with read-only access to a schema of another user. My
functions work with anonymous tables (I mean, there is no prefix of the
schema), and when I invoke those functions, I got errors about not
knowing the relations (tables).

How can I change the search_path in a persistent way for a read-only
user that not owns the schema, to avoid set it in every session?

I even don't know if the set search_path works at run-time, but even
with that, it's annoying put it on the top of each function...

thanks,
Pedro Salazar.
-- 
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61

Re: set persistent search_path

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Pedro Salazar  writes:
> How can I change the search_path in a persistent way for a read-only
> user that not owns the schema, to avoid set it in every session?

See "ALTER USER SET variable".

			regards, tom lane

FAQ