Postgres Pro
Downloads
Home   >   mailing lists

Thread: Clarification needed

Clarification needed

From
PG Doc comments form
Date:
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.

Re: Clarification needed

From
Tom Lane
Date:
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

Re: Clarification needed

From
"Dean Gibson (DB Administrator)"
Date:
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.