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.