Re: Quoting table/column names vs performance

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(at)styxsystems(dot)com
+420 608 782 813

-----Original Message-----
From: Alban Hertroys [mailto:dalroi(at)solfertje(dot)student(dot)utwente(dot)nl]
Sent: Wednesday, April 09, 2008 7:12 PM
To: Jozef Ševčík
Cc: pgsql-general(at)postgresql(dot)org
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!