Postgres Pro
Downloads
Home   >   mailing lists

Re: a database can be created but not droped - Mailing list pgsql-general

From Frank Streitzig
Subject Re: a database can be created but not droped
Date
Msg-id YuedQZ9nA+bLJiyT@frastr-dev
Whole thread Raw
In response to a database can be created but not droped  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
Tree view 
Am Mon, Aug 01, 2022 at 11:22:33AM +0200 schrieb Matthias Apitz:
> 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?

Please try: DROP DATABASE IF EXISTS "SRP-27097" WITH FORCE;

Best rehards
Frank

pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: a database can be created but not droped
Next
From: howardnews@selestial.com
Date:
Subject: Re: Connecting to postgres on OSX from Swift using PostgresClientKit