Bugzilla – Bug 3157
Quoting column names in forward engineering using postgres
Last modified: 2016-02-09 16:12:35 EST
This suggestion form post :2780
"Is it possible to tell the forward engineer process to quote column names
(postgresql) in the SQL output. I'm using the 1.06 distribution with Postgresql
9.04. I have a database that I want to have some "camel-case" names in (it was
reverse engineered from a different database and I don't want to rename every
column) but postgres lower cases everything if it isn't quoted. Don't know if
this is a feature request or I don't know how to set some options. Thanks --
love the tool. "
I think we should implement this feature as if user wants to quote a column
then should select from some property box/check box. we shouldn't forcefully
apply this feature of quoting a columns .Some users may not want the column
names to be quoted.
This improvement done in build #12.
To apply quote during forward engineering for Postgres only.
In order to apply quotes follow these steps:
1) go to Preference option
2) select 'Local JDBC Drivers' tab
3) select 'PostgresSQL' from left panel
4) select ''Advanced Properties' tab
5) check "Quotes Name" check Box and click OK.
So this will apply quotes to all physical name during "forward engineering" for
PostgresSQL Database type.
Added a property of quoting column name during 'forward engineering'( feature
of 'SQL Power Architect' ) using Postgres database. Related to Bug 3157.
Added a NullPoint check.