'@' in password

[timothyjlaurent]

I have an '@' symbol in a password. I tried escaping it with '@' but this also didn't work.

[amjith]

That's most definitely a bug. I wonder how psql handles this.

In the meantime you can try using the command line switches to prompt for the password instead of using the postgres:// style url.

pgcli -h localhost -p 5432 -U amjith -W app_db

Launching that way will prompt for the password.

[jackmaney]

Have you tried URL-escaping the @ to %40?

[drocco007]

Have you tried with the latest pgcli? I successfully connected using a role with an '@' character using pgcli 0.16.0 against a 9.4 server:

postgres=# create role atpw LOGIN PASSWORD '@at';
CREATE ROLE
postgres=# create database atdb owner atpw;
CREATE DATABASE
postgres=# \q

$ pgcli postgres://atpw:@at@localhost:5432/atdb
Version: 0.16.0
Chat: https://gitter.im/amjith/pgcli
Mail: https://groups.google.com/forum/#!forum/pgcli
Home: http://pgcli.com
atdb> 

[amjith]

Previously I was using my own custom built parsing routine for extracting the password and username from the postgres url. I've replaced that routine with urlparse from python stdlib. So this might not be an issue anymore.

Thanks @drocco007 for testing it. I'll close the issue.

[catando]

The issue seems to persist/have returned:

pgcli postgres://atpw:@at@localhost:5432/atdb
could not translate host name "at@localhost" to address: nodename nor servname provided, or not known

A workaround is to escape the @s with sed:

pgcli postgres://atpw:"$(echo '@at'|sed -e s/@/\%40/g)"@localhost:5432/atdb

[j-bennet]

@catando What is your pip freeze output?

[przdev]

@timothyjlaurent

for @ in password you need to encode @ with %40 and quote whole uri
ex: pgcli 'postgresql://postgres:%40postgres@localhost:5432/postgres'
also with arguments use same
ex: pgcli -h localhost -U postgres -W '@postgres' -d postgres
tested it works

[przdev]

@j-bennet @amjith above solution work, so you can close issue (if need to add it in readme than I'll happy to contribute)

[j-bennet]

@przdev A note in readme would be good, or better yet, in the docs on the pgcli.com website. Here is the link to docs source:

https://github.com/dbcli/pgcli.com/blob/master/content/pages/3.docs.md