Re: Search path

On 10/24/19 9:41 AM, stan wrote:
> I just was educated on the security issues of search path. As a result
> I am going to define a schema for the project we are working on.
> I set this in  postgresql.conf
> 
> search_path = 'ica , "$user", public'
> 
> Here is the question. Will this path be in effect for users connecting from
> MS Access clients? The name of this file makes me think that it only
> controls instances of psql, but I need this to be effective for all
> connections to the database.
> 

It is under:

Client Connection Defaults
https://www.postgresql.org/docs/11/runtime-config-client.html

so it works for clients that connect to Postgres not just psql. I can 
confirm it works with Access.


-- 
Adrian Klaver
adrian.klaver@aklaver.com