From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | a database can be created but not droped |
Date: | 2022-08-01 09:22:33 |
Message-ID: | 20220801092233.GA9@sh4-5.1blu.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
This is with 14.1 on Linux. I have created a new database with
$ createdb -U sisis -T template0 SRP-27097
I can connect to it, created tables and fill them with SQL:
$ psql -Usisis -dSRP-27097
psql (14.1)
Geben Sie »help« für Hilfe ein.
SRP-27097=# select count(*) from sisisinst;
count
-------
2
but I can not drop the database:
$ psql -Usisis -dtestdb
psql (14.1)
Geben Sie »help« für Hilfe ein.
testdb=# DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
ERROR: syntax error at or near "-"
ZEILE 1: DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
Why is this?
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2022-08-01 09:27:53 | Re: a database can be created but not droped |
Previous Message | Rejo Oommen | 2022-08-01 08:12:33 | Is Client connections via ca.crt only possible? |