| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Jozef Ševčík <sevcik(at)styxsystems(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Quoting table/column names vs performance |
| Date: | 2008-04-09 17:11:57 |
| Message-ID: | 3164D567-E59A-4274-B803-7375E08FB6FF@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:737,47fcf8df927661984376163!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-09 17:12:30 | Re: Disable Triggers |
| Previous Message | Jozef Ševčík | 2008-04-09 17:02:45 | Re: Quoting table/column names vs performance |