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