Hi Adrian, > On 05. Oct, 2020, at 19:20, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > Actually it does: > > From the prompt I'm guessing you are logging in as 'postgres' user. In that case "$user" will become postgres and you will get: > > postgres=# select current_schemas(false); > current_schemas > ------------------- > {postgres,public} > > The current_schemas(true) case will include implicit schemas that are 'always'(as I'm sure that someone will come up with the exception) there. yes, I am. And I know about the false case. It did it just out of curiosity, not to cause confusion here, sorry. Cheers, Paul