Re: How do I get rid of database test-aria - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How do I get rid of database test-aria
Date
Msg-id 73ea9951-43a0-4a71-effe-4cc57d240cb4@aklaver.com
Whole thread Raw
In response to How do I get rid of database test-aria  (Sherman Willden <operasopranos@gmail.com>)
Responses Re: How do I get rid of database test-aria  (Sherman Willden <operasopranos@gmail.com>)
List pgsql-general
On 02/13/2018 12:38 PM, Sherman Willden wrote:
> development platform: HP Compaq 6710b
> postgresql 9.6
> Operating System: Ubuntu 17.10
> 
> It probably doesn't matter since there is nothing in the database. I 
> don't remember  how I created the database. It appears that postgresql 
> does not like a dash in the database name. I have not tried to create a 
> table under the database. When I try to drop the database I get the 
> following..
> 
> date_time=# DROP DATABASE test-aria;
> ERROR:  syntax error at or near "-"
> LINE 1: DROP DATABASE test-aria;

DROP DATABASE "test-aria";

See below for more info:

https://www.postgresql.org/docs/10/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

> 
> Thanks;
> 
> Sherman


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: How do I get rid of database test-aria
Next
From: armand pirvu
Date:
Subject: Re: cursors and function question