Обсуждение: How do I get rid of database test-aria

Hi

> On 13.02.2018, at 21:38, Sherman Willden <operasopranos@gmail.com> 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
appearsthat 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;
>

Does
DROP DATABASE "test-aria";
work?

Regards
Charles

> Thanks;
>
> Sherman

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

On 02/13/2018 03:08 PM, Sherman Willden wrote:
> 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.

The below explains why:

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


> 
> Thanks all;
> 
> Sherman
> 
> On Tue, Feb 13, 2018 at 1:41 PM, Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto: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
>     <https://www.postgresql.org/docs/10/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS>
> 
> 
>         Thanks;
> 
>         Sherman
> 
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com