Handling password with special characters

[khteh]

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

[jelder]

Try URL-encoding special characters. For example, a password with a space would need to use %20 instead.

[khteh]

That's not the point yet, at least now as it doesn't use ~/.pgpass. https://pgloader.readthedocs.io/en/latest/command.html#connection-string