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
|
| Список | 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;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 по дате отправления: