Bug 3157 - Quoting column names in forward engineering using postgres
: Quoting column names in forward engineering using postgres
Product: Bug Database
: 3.6.2
: All All
: P5 enhancement
: ---
Assigned To: kirti
: http://www.sqlpower.ca/forum/posts/li...
  Show dependency treegraph
Reported: 2015-03-05 11:03 EST by kirti
Modified: 2016-02-09 16:12 EST (History)
1 user (show)

See Also:


Note You need to log in before you can comment on or make changes to this bug.
Description kirti 2015-03-05 11:03:00 EST
This suggestion form post :2780

kenw wrote:
"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.
Comment 1 kirti 2015-04-02 09:14:19 EDT
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.
Comment 2 kirti 2016-02-09 16:10:02 EST
Added a property of quoting column name during 'forward engineering'( feature
of 'SQL Power Architect' ) using Postgres database. Related to Bug 3157.
Comment 3 kirti 2016-02-09 16:12:35 EST
Added a NullPoint check.