0

When I do \l I see myexampledb, then I do dropdb 'myexampledb' in the terminal, I got no error, I do \l again, the db isn't deleted, what's wrong?

I did this exactly:

  1. I do psql
  2. I got error of psql: FATAL: database "steven" does not exist
  3. I do psql -d postgres
  4. I do dropdb 'postgres'
  5. I do \ls
  6. the postgres db isn't removed
Improve this question
5
  • Please show us exactly where and how you ran those query. Commented Dec 13, 2018 at 14:59
  • @a_horse_with_no_name updated my question, I'm curious why do I have error in step 2 Commented Dec 13, 2018 at 15:03
  • you need to createdb steven first. Commented Dec 13, 2018 at 15:05
  • @a_horse_withi_no_name which command I need ;? I can't do dropdb 'postgres';`, I got syntax error. Commented Dec 13, 2018 at 15:06
  • any clue why I got postgres=# dropdb 'postgres'; ERROR: syntax error at or near "dropdb" LINE 1: dropdb 'postgres'; ^ postgres=# ?? Commented Dec 13, 2018 at 16:05
Related questions
1251
Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
1040
psql: FATAL: database "<user>" does not exist
638
"use database_name" command in PostgreSQL
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.