Skip to main content
Open

Postgres writer - add force lowercase names checkbox

Related products:Integrations
siennaatsafe
ebygomm
bruceharold
arnovananrooij
ponceta
+7
  • siennaatsafe
    siennaatsafe
  • ebygomm
    ebygomm
  • bruceharold
    bruceharold
  • arnovananrooij
    arnovananrooij
  • ponceta
    ponceta
  • r5
    r5
  • hallkbrdz
  • richardnairn
  • roland.martin
    roland.martin
  • jpvo
    jpvo
  • kole
  • chris_m
    chris_m

Todo: For the PostgreSQL/PostGIS writer, add a checkbox to force the schema, table name, and all column names to lower case.

Why: When converting from databases like Oracle where everything is by default uppercase, to PostgreSQL where everything by default is lowercase, the Dynamic setting creates everything as-is, which is normally good - but in this case keeps everything uppercase which is undesirable. Adding a checkbox to force everything lower either at the writer level (most desirable), or the table level would be most helpful.

My use-case: I have an Oracle production GIS database with over 4600 tables to convert to PostgreSQL. I don't look forward to having to touch each stream to add a bulkattributerenamer and set the schema and table names.

4 replies

roland.martin
Forum|alt.badge.img+9

I thought I was going crazy for a minute - I requested this about 12 years ago... but it's still there when you add a new connection:

'

That's exactly what you're describing, isn't it?


Forum|alt.badge.img
  • Author
  • July 12, 2018

Yes, and as I understand it that is supposed to make the column names (attributes) lower case. And yes, when the attribute names are copied over they do become lower case.

 

However when used with dynamic mode with a source like Oracle which is all upper:

- You now have all the source attribute names upper case and the destination names lower case - so they don't match and connect

'

- The schema name is copied as upper case

- The table name is copied as upper case

What is desired is that when checked the writers:

- Connect all incoming source attribute names in whatever case to lower case attribute names

- Force the schema name to lower case

- Force the table name to lower case

This will allow a simple one to one connection using dynamic mode without having to add anything in between or with additional changes to the schema and table name properties for each table.


fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • July 14, 2018
Yup. Dynamic needs this treatment. Noted.

 

 


Forum|alt.badge.img
  • Author
  • August 16, 2018
BTW, if you are thinking about trying to use the BulkAttributeRenamer to work around this for new table creations, don't. Although it will fix the case, it will also make all your attributes varchar(200). For bulk loads into existing tables that is not an issue as the type is not modified.

 

 

Hopefully this gets in the 2019 beta, as I don't look forward to lowercasing all those tables attribute names by hand (ouch).

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings