How do I remove database from postgresql native app on mac?

Question

I am trying to remove a db in postgresql but its still viewable in the mac native app even after I have confirmed its been removed from the terminal. Should I be concerned?

Here is my terminal command and output

drop database if exists Javascript_Rails_Project_development;
NOTICE:  database "javascript_rails_project_development" does not exist, skipping
DROP DATABASE

database image

sticky bit · Accepted Answer · 2020-07-04 05:51:06Z

1

You possibly created the database putting its name in double quotes as "Javascript_Rails_Project_development". Note the upper case letters.

Usually identifiers in SQL are case insensitive. If you quote them in such a way however, they become case sensitive. That is, there is no database named javascript_rails_project_development as the letters are all lower case.

Once created with the name double quotes and including upper case characters you need to address the object afterwards by a name in double quotes with the exact matching cases of the letters.

Try:

DROP DATABASE IF EXISTS "Javascript_Rails_Project_development" ;

And possibly avoid upper case and quoted names in the future all together. It's just making things more complicated in most of the cases.

answered Jul 4, 2020 at 5:51

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I remove database from postgresql native app on mac?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related