Re: Dash in Extension Names - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: Dash in Extension Names
Date
Msg-id CAJW2+qf6CHYO9VDzt2iR+rojocTv8K=FCnMoaKSAh-QLaARfAQ@mail.gmail.com
Whole thread Raw
In response to Dash in Extension Names  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Dash in Extension Names
List pgsql-hackers
On Fri, Nov 11, 2011 at 14:40, David E. Wheeler <david@kineticode.com> wrote:
> one might use "-" in the name itself, but probably not "--" -- it seems that the dash is not actually allowed:
>
>    create extension pgtap-core;
>    ERROR:  syntax error at or near "-"
>    LINE 1: create extension pgtap-core;
>
> Parser error?

You need double-quotes around the name:
=# CREATE EXTENSION "uuid-ossp";
CREATE EXTENSION

--
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Dash in Extension Names
Next
From: Nikhil Sontakke
Date:
Subject: Re: Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers