Clarification needed
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-pgpass.html
Description:
Web page https://www.postgresql.org/docs/13/libpq-pgpass.html
Are the fields in the .pgpass file case sensitive by default? Obviously the
password is, & it appears that at least the username is.
PG Doc comments form <noreply@postgresql.org> writes:
Are the fields in the .pgpass file case sensitive by default?
Yes. User name and database name clearly must preserve case
distinctions. Maybe there is an argument for the host name
to be matched case-insensitively, but I think it could cause
problems when the host string is a socket path name.
regards, tom lane
On 2021-06-12 12:47, Tom Lane wrote:
PG Doc comments form <noreply@postgresql.org> writes:
Are the fields in the .pgpass file case sensitive by default?
Yes. User name and database name clearly must preserve case
distinctions. Maybe there is an argument for the host name
to be matched case-insensitively, but I think it could cause
problems when the host string is a socket path name.regards, tom lane
No argument from me; I like it the way it is. I just posted the
comment as a potential update to the web page. Unless it is covered
elsewhere.