Hi all,

I just switched from MS SQL to PostgreSQL on project and have question about 
double-quoting names of fields/tables
regarding to performance.

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.
I know I may rename tables/fields to lowercase and avoid double-quotting, but 
it double-quotting has no
affect on perf. is it worth it ?
Or are there any advantages of using 'non-quoted' identifiers agains 
double-quoted ?

Thanks

S pozdravom / Best regards,

Jozef Ševčík
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
+420 608 782 813

Reply via email to