dropdb mydb not working in postgres

Question

I am a complete beginner with postgresql. I created a test database called iswdp and now I want to delete it. When I do:

dropdb iswdp

the command returns no output and when I \list the table iswdp is still there.

dropdb iswdp;

returns:

ERROR: syntax error at or near "dropdb" LINE 1: dropdb iswdp

I used:

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname = current_database()
AND pid <> pg_backend_pid();

which I found from another stackoverflow post to disconnect from all databases then attempted dropdb iswdp again with the same result.

I'm stuck, can someone help me? I'm doing this on linux mint from the bash terminal.

jmelesky · Accepted Answer · 2017-07-18 17:20:44Z

9

The command dropdb is a command issued from a shell prompt. From a sql prompt (like psql), you would want to issue a DROP DATABASE command.

I recommend opening psql and issuing DROP DATABASE iswdp;. That should work.

You may get an error that looks like ERROR: cannot drop the currently open database, which will happen if you connect to iswdp and try to drop it. If that happens, try instead to connect to the postgres database, and issue the same DROP DATABASE command. It should work.

answered Jul 18, 2017 at 17:20

jmelesky

4,1101 gold badge26 silver badges25 bronze badges

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

Comments

Anthony Sotolongo · Accepted Answer · 2017-07-19 15:01:12Z

3

dropdb is a commando from shell not from psql program, from psql the commnado is drop database iswp;

answered Jul 19, 2017 at 15:01

Anthony Sotolongo

1,6882 gold badges13 silver badges23 bronze badges

Collectives™ on Stack Overflow

dropdb mydb not working in postgres

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related