| From: | Kirk Wolak <wolakk(at)gmail(dot)com> |
|---|---|
| To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
| Cc: | pf(at)pfortin(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: psql and pgpass.conf on Windows |
| Date: | 2023-07-03 15:10:12 |
| Message-ID: | CACLU5mRqJ=CN7KBV8gPbE9P9wjfYd_Khr9gwGXVy_yA55ggvUQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Jul 1, 2023 at 2:07 AM Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
> On Sat, Jul 01, 2023 at 01:40:49AM -0400, Kirk Wolak wrote:
> >
> > FWIW, I discovered that psql is case sensitive on the dbname, without
> > quoting it!
>
> That's on purpose, since shell quoting behavior is entirely different from
> SQL.
> The quotes are discarded by the shell, so it would otherwise require users
> doing something like
>
> psql -d '"MyDbName"'
>
> The behavior is the same for all client tools, and other object arguments
> like
> username.
>
Thanks,
I was mentioning it in case the person who could not figure out why his
pgpass.conf was not being hit correctly,
might have multiple things colluding against them.
It's nice to know it is consistent, and applies to usernames.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2023-07-04 12:21:10 | psql -c command parse "select $$hello$$" failed |
| Previous Message | Julien Rouhaud | 2023-07-03 09:36:31 | Re: Query regarding managing Replication |