Nick Johnson wrote: > > The following bug has been logged online: > > Bug reference: 2690 > Logged by: Nick Johnson > Email address: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
