Hi Bruno, Thanks... (maybe include this in the manuals, I couldn't find this information...)
Best Regards Marcus On Apr 10, 2005 11:23 PM, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Tue, Apr 05, 2005 at 18:09:25 +0100, > "Marcus v. Scotti" <[EMAIL PROTECTED]> wrote: > > > > Description: Problem with capitalised DB names... > > Details: > > > > When trying to grant database privileges to a group of users there is no way > > to do this if the database name is capitalised (i.e. db-name = Test). The > > error message when performing the grant operation: > > > > grant all on DATABASE test to group tgroup; > > > > is: > > > > ERROR: database "test" does not exist > > > > I have used capitalisation an a number of databases, so this now seems to > > require me to rename them all in to lower-case... > > You need to use double quotes (") around database, table or column names that > are not all lowercase. > -- Marcus v. Scotti Director Fry-IT LTD www.fry-it.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq