How to query a PostgreSQL table with upper case letter or column with upper case letter | Community
Skip to main content
Y
yueminspb
Level 3
November 17, 2020
Solved

How to query a PostgreSQL table with upper case letter or column with upper case letter

  • November 17, 2020
  • 1 reply
  • 3136 views

Hi Team,

We encounter a external data base issues. The external data base table name with some upper case letters and also the column name. It seems that the DataLoading activity of workflow can not read these table. Just wonder if there is a workaround to solve this problem?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

hi,

 

It's a known issue on PostgreSQL. You should change you column names to lowercase.

Alternatively, you can create a view with columns to lowercase letter but it's not the best solution compared to changing the column names itself in the table, as views will have performance impacts.

 

Thanks,

David  

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
November 17, 2020

hi,

 

It's a known issue on PostgreSQL. You should change you column names to lowercase.

Alternatively, you can create a view with columns to lowercase letter but it's not the best solution compared to changing the column names itself in the table, as views will have performance impacts.

 

Thanks,

David  

David Kangni
Y
yueminspbAuthor
Level 3
November 18, 2020
Hi David, thanks for your suggestion
Terms & ConditionsAccessibility statement

Loading footer...