Hi Adrian,
> On 05. Oct, 2020, at 19:20, Adrian Klaver <adrian.klaver@aklaver.com> 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
willget:
>
> 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
withthe 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