SevenAteAnthony
asked on
ERROR: database "name" is being accessed by other users DETAIL: There are 1 other session(s) using the database.
Hi Experts,
Thanks for reading. I'm completely new to PostgreSQL and need to drop some databases I've created, however, I cannot. I'm using Navicat and pgAdmin3 to try and both times I cannot. Each time I click the database it seems to establish a connection but I have to click it to get the delete right-click option. I cannot figure out for the life of me nor on Google how to delete them. How can I do this?
Thank you!
Thanks for reading. I'm completely new to PostgreSQL and need to drop some databases I've created, however, I cannot. I'm using Navicat and pgAdmin3 to try and both times I cannot. Each time I click the database it seems to establish a connection but I have to click it to get the delete right-click option. I cannot figure out for the life of me nor on Google how to delete them. How can I do this?
Thank you!
ASKER
Thanks, earthman2. What is this command line tool you speak of?
dropdb.exe
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
dropdb DBNAME