| From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | byrnejb(at)harte-lyne(dot)ca, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: UUID generation problem |
| Date: | 2020-10-05 17:22:34 |
| Message-ID: | 631C38D6-2ABA-4142-A05F-32001CD25B3E@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Adrian,
> On 05. Oct, 2020, at 19:20, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-10-05 17:24:04 | Re: UUID generation problem |
| Previous Message | Adrian Klaver | 2020-10-05 17:20:02 | Re: UUID generation problem |