Handling password with special characters

For example $. I added the following to ~/.pgpass but to no avail:

*:*:*:username:P@$$w0rd

as it still uses my Linux username:

$ echo $PGPASSFILE
/home/khteh/.pgpass
$ pgloader sqlite.load
2026-07-27T07:29:58.005001Z LOG pgloader version "3.6.10~devel"
2026-07-27T07:29:58.006001Z LOG Data errors in '/tmp/pgloader/'
2026-07-27T07:29:58.006001Z LOG Parsing commands from file #P"/usr/src/Python/customer-support-agent/src/utils/sqlite.load"
KABOOM!
DB-CONNECTION-ERROR: Failed to connect to pgsql at "10.152.183.145" (port 5432) as user "khteh": The value
  NIL
is not of type
  STRING
when binding STRING
An unhandled error condition has been signalled:
   Failed to connect to pgsql at "10.152.183.145" (port 5432) as user "khteh": The value
  NIL
is not of type
  STRING
when binding STRING




What I am doing here?

Failed to connect to pgsql at "10.152.183.145" (port 5432) as user "khteh": The value
  NIL
is not of type
  STRING
when binding STRING

Start by reproducing the connection with the shown ~/.pgpass entry, PGPASSFILE value, and sqlite.load command. Trace how pgloader reads the PostgreSQL password and handles special characters; done means the command authenticates with the configured password instead of falling back to the Linux username.