I normally get to the console in UBUNTU by typing:
sudo -u postgres psql
But I need to delete a database owned by a different user.
When I type:
sudo -u username psql
It tells me "database "username" does not exist.
But… I wasn't trying to connect to a database, I was trying to connect as a user.
Best Answer
psql
assumes you want to connect to the database named as the current user if you don't provide any login details.But you can ovverride the defaults using parameters to
psql
, there is no need to usesudo
in order to connect as a different username.Simply run:
where username is the user you want to use and databasename the database you want to connect to.
If you don't know which database you can connect to, use
to show them all.
All this and a lot more is nicely documented in the manual: http://www.postgresql.org/docs/current/static/app-psql.html