Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Quoting tab...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15236 of 17602
Post > Topic >>

Re: Quoting table/column names vs performance

by dalroi@[EMAIL PROTECTED] (Alban Hertroys) Apr 9, 2008 at 07:11 PM

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!



-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Re: Quoting table/column names vs performance
dalroi@[EMAIL PROTECTED]   2008-04-09 19:11:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 18:38:12 CST 2008.