Re: a database can be created but not droped

From: Frank Streitzig <fstreitzig(at)gmx(dot)net>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: a database can be created but not droped
Date: 2022-08-01 09:30:41
Message-ID: YuedQZ9nA+bLJiyT@frastr-dev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message howardnews 2022-08-01 11:11:10 Re: Connecting to postgres on OSX from Swift using PostgresClientKit
Previous Message Julien Rouhaud 2022-08-01 09:27:53 Re: a database can be created but not droped