Re: BUG #2690: GRANT does not allow periods in database or schema names

Nick Johnson wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2690
> Logged by:          Nick Johnson
> Email address:      pgsql@spatula.net
> PostgreSQL version: 8.1.1
> Operating system:   FreeBSD 6.1
> Description:        GRANT does not allow periods in database or schema names
> Details:
>
> Though you can create a database with a period in the name (e.g.,
> "example.com"), you cannot issue a GRANT on that database name from the
> command line.

Sure you can.  Just quote the name:

GRANT ALL ON DATABASE "example.com" TO someuser;

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.