I have been trying to delete databases from my PostgreSQL service, I started the service, ran
sudo sudo -u postgres psql
Listed my databases with
But whenever I run
DROP DATABASE mydatabasename; I get
postgres-# DROP DATABASE mydatabasename; ERROR: syntax error at or near "DATABASE"
I also tried with
dropdb but it doesn’t work, how could I overcome this problem?