Hi Alban, If I do: select * from SourceCategory pgAdmin gives me an error: ERROR: relation "sourcecategory" does not exist If I do: select * from "SourceCategory" It works OK. As Richard mentioned, it's because table was probably created with CREATE TABLE "SourceCategory". I was not sure about this because I had no control over creating the tables. S pozdravom / Best regards, Jozef Ševčík sevcik@xxxxxxxxxxxxxxx +420 608 782 813 -----Original Message----- From: Alban Hertroys [mailto:dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx] Sent: Wednesday, April 09, 2008 7:12 PM To: Jozef Ševčík Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Quoting table/column names vs performance On Apr 9, 2008, at 5:27 PM, Jozef Ševčík wrote: > In MSSQL I had something like: > SELECT Column1,Column2 from MyTable > > In PgSQL I write: > SELECT “Column1”, “Column2” from “MyTable” > > Which is fine and working, I have no doubt about it. I’m just > guessing if this does not affect performance > in any way. What are you trying to fix that you don't just write SELECT Column1,Column2 from MyTable ? Postgres understands that fine, why do you want to quote those identifiers? Maybe your application code is case-sensitive with regards to column (and maybe table) names? Regards, Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:806,47fcf8e1927661781427083!
