Re: How do I get rid of database test-aria

Поиск
Список
Период
Сортировка
От Sherman Willden
Тема Re: How do I get rid of database test-aria
Дата
Msg-id CAGv-wXGQse5oa7Q4S8MyyQUmOXk6LFutBcJi717gZqy6GLLSsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How do I get rid of database test-aria  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How do I get rid of database test-aria  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: I do not get the point of the information_schema
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How do I get rid of database test-aria