Error connecting to Heroku DB with PGAdmin

Question

I followed the instructions to Connect to a heroku database with pgadmin. What might cause the following error?

ERROR: column "*my database identifier*" does not exist. 
LINE 9: WHERE datname IN (*my database identifier*)

To be clear my database identifier is the alphanumeric string listed in next to "Database" in HerokuPostgres Connection Settings.

Answer 1

You forgot to quote the identifier as a string literal, so PostgreSQL treats it as a column name - for a column that doesn't exist. Try:

WHERE datname IN ('my_database_identifier');

Note the single quotes.