I have psql installed in my Ubuntu system. There is a database named tmpdb in it. I want to delete it but get an error message:
must be owner of database tmpdb".
I open psql with
$psql postgres psql (9.5.6) Type "help" for help. postgres=>DROP DATABASE tmpdb; ERROR: must be owner of database tmpdb postgres=>
How can I see owner, change it, so I can delete the database?