Jozef =A9ev=E8=EDk wrote:
> Hi all,
>=20
> I just switched from MS SQL to PostgreSQL on project and have
> question about double-quoting names of fields/tables regarding to
> performance.
If the cost of quoting column-names is a significant part of your query=20
costs, you must have some very fast queries. I would not worry.
> In MSSQL I had something like: SELECT Column1,Column2 from MyTable
>=20
> In PgSQL I write: SELECT "Column1", "Column2" from "MyTable"
>=20
> 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
If you double-quote identifiers when you create them you'll want to=20
double-quote them everywhere they are used. That's OK with a new sytem,=20
but can be awkward if you have a lot of existing code that isn't
already=20
quoted.
--=20
Richard Huxton
Archonet Ltd
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
