[GENERAL] Re: Database Name Case Sensitivity

2001-04-05 Thread Joel Burton
On Thu, 5 Apr 2001, ADBAAMD wrote: > Brian T. Allen wrote: > > > I just ran into that too, and find it most undesirable. I don't know > > whether that is part of the SQL spec or not, but it seems very odd. The > > queries seem to be converted to lowercase before they ever reach the SQL > > eng

Re: [GENERAL] Re: Database Name Case Sensitivity

2001-04-05 Thread Brian T. Allen
I am sure it is a Good Thing, thank you for the explanation. I will just have to change my thinking to all lowercase and get used to it. Sort of on the same topic, does anyone know of a PostgreSQL primer for those making the change from MySQL. Changing religions :} is never easy, something to

[GENERAL] Re: Database Name Case Sensitivity

2001-04-05 Thread Mitch Vincent
I'm not sure about database names but table and field names can be upper case (or contain upper case characters) you just have to reference the table/field in double quotes.. Example : SELECT * FROM "FoBaR"; Hope that helps. -Mitch Software development : You can have it cheap, fast or working.

[GENERAL] Re: Database Name Case Sensitivity

2001-04-05 Thread Joel Burton
On Thu, 5 Apr 2001, Brian T. Allen wrote: > I just ran into that too, and find it most undesirable. I don't know > whether that is part of the SQL spec or not, but it seems very odd. The > queries seem to be converted to lowercase before they ever reach the SQL > engine. Everything is postgres