can't drop db posgres using dropdb command in terminal?

Asked Dec 13 '18 at 14:58

Active Dec 13 '18 at 15:05

Viewed 349 times

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:

I do psql
I got error of psql: FATAL: database "steven" does not exist
I do psql -d postgres
I do dropdb 'postgres'
I do \ls
the postgres db isn't removed

edited Dec 13 '18 at 15:03

asked Dec 13 '18 at 14:58

Hoknimo

Please show us **exactly** where and how you ran those query. – Dec 13 '18 at 14:59
@a_horse_with_no_name updated my question, I'm curious why do I have error in step 2 – Hoknimo Dec 13 '18 at 15:03
you need to `createdb steven` first. – Dec 13 '18 at 15:05
@a_horse_withi_no_name which command I need `;`? I can't do dropdb 'postgres';`, I got syntax error. – Hoknimo Dec 13 '18 at 15:06
any clue why I got `postgres=# dropdb 'postgres'; ERROR: syntax error at or near "dropdb" LINE 1: dropdb 'postgres'; ^ postgres=#` ?? – Hoknimo Dec 13 '18 at 16:05

can't drop db posgres using dropdb command in terminal?

0 Answers0