Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2690: GRANT does not allow periods in database or schema names - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2690: GRANT does not allow periods in database or schema names
Date
Msg-id 22081.1160771742@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2690: GRANT does not allow periods in database or schema names  ("Nick Johnson" <pgsql@spatula.net>)
List pgsql-bugs
Tree view 
"Nick Johnson" <pgsql@spatula.net> writes:
> 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.

You need some double quotes:
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

This is by no means unique to GRANT, nor to database names.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2690: GRANT does not allow periods in database or schema names
Next
From: Tom Lane
Date:
Subject: Re: BUG #2691: Server did not start. Error: Could not create log file.