Postgres Pro
Downloads
Home   >   mailing lists

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

From Sherman Willden
Subject Re: How do I get rid of database test-aria
Date
Msg-id CAGv-wXGQse5oa7Q4S8MyyQUmOXk6LFutBcJi717gZqy6GLLSsg@mail.gmail.com
Whole thread Raw
In response to Re: How do I get rid of database test-aria  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How do I get rid of database test-aria
List pgsql-general
Tree view
Yes the double quotes worked. I tried single quotes but since that didn't work I just assumed that double quotes would not work either.

Thanks all;

Sherman

On Tue, Feb 13, 2018 at 1:41 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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: "David G. Johnston"
Date:
Subject: Re: I do not get the point of the information_schema
Next
From: Adrian Klaver
Date:
Subject: Re: How do I get rid of database test-aria