Discussion
3
Replies
704
Views
Areteans Technology
Posted: 5 years ago
Last activity: 5 years 1 month ago
Postgres - tables with camelcase or capital letters are not handled properly at generate data table mapping wizard
Hello Pega team,
The Database Table Class Mapping wizzard was not able to generate column-property mapping when a postgres table has capital letters in it ? now postgres has no strict rules about the naming conventions of a table or column, do pega has any restriction of table name being all non caps ?
Posted: 5 years ago
Posted: 5 years ago
How about the table name?
Is it recommended to be in small letters always?
Posted: 5 years ago
Yes, please.
My experience has been that using the Database Table Class Mapping wizard with PostgreSQL, the column names are preferably in lowercase. If you're not able to generate the column mapping, can you manually add them into the class later?