When trying to make a UNIQUE constraint, pgAdmin 4 got confused and couldn't continue just because my field name contained a space. For some absurd reason, it doesn't add the quotes around identifiers and thus breaks for anyone who doesn't code with 1970s-era, US-centric name conventions. It displayed it to me as "stuff%20whatever" when the name was "stuff whatever".
This is working fine for me with the latest pgAdmin 4. Please try with the latest pgAdmin 4 and if in case you still face the issue, please log the issue @ https://redmine.postgresql.org/projects/pgadmin4 with the below details.
1) pgAdmin 4 version and OS details
2) Screen-shots
Thanks,
Khushboo
I was forced to figure out how to do it in raw SQL.