Postgres Pro
Downloads
Home   >   mailing lists

Re: set persistent search_path - Mailing list pgsql-admin

From Tom Lane
Subject Re: set persistent search_path
Date
Msg-id 29322.1049727659@sss.pgh.pa.us
Whole thread Raw
In response to set persistent search_path  (Pedro Salazar <pedro-b-salazar@ptinovacao.pt>)
List pgsql-admin
Tree view 
Pedro Salazar <pedro-b-salazar@ptinovacao.pt> 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

pgsql-admin by date:

Previous
From: Pedro Salazar
Date:
Subject: set persistent search_path
Next
From: "Cristina Surroca"
Date:
Subject: Trying to Tunning DB