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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nick Johnson" <pgsql(at)spatula(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2690: GRANT does not allow periods in database or schema names
Date: 2006-10-13 20:35:42
Message-ID: 22081.1160771742@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Nick Johnson" <pgsql(at)spatula(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-10-13 20:43:33 Re: BUG #2691: Server did not start. Error: Could not create log file.
Previous Message Peter Eisentraut 2006-10-13 20:33:29 Re: BUG #2690: GRANT does not allow periods in database or schema names