[Dbix-class] DBIx, Postgres and Camel Case in field and table names

Jan Eskilsson janeskil1525 at gmail.com
Mon Feb 23 10:01:27 GMT 2015


Hi All

I'm in a situation where i need to connect to a legacy PostgreSQL database
where field and table names are written in Camel Case hence in Postgres
they need to be quoted. Is there a way to make DBIx automatically quote
table and field names in the generated SQL ?

For example

SELECT City FROM CVU.HeadQuarter WHERE Type = 100 Need to be generated as
SELECT "City" FROM "CVU"."HeadQuarter" WHERE "Type" = 100

Thank you in Advance !

Best Regards
Jan Eskilsson

-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

Please consider the environment before you print this email.

(1) The contents of this transmission are privileged and confidential and
intended solely for the use of the addressee. Any disclosure, distribution
or copying of the contents, other than by the addressee, is strictly
prohibited. If you receive this transmission in error, please notify us
immediately and destroy the material received.
(2) All incoming and outgoing emails and any attachments are subjected to a
virus scanner and are believed to be free of any virus, or any other defect
which might affect any computer or IT system into which they are received
and opened. Therefore, it is the responsibility of the recipient to ensure
that they are virus free and no responsibility is accepted by Jan Eskilsson
 for any loss or damage arising in any way from receipt or use thereof.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20150223/bbb77e76/attachment.htm>


More information about the DBIx-Class mailing list