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

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com