• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 88
  • Last Modified:

How can i default all characters in PostgreSQl to CAPITAL

I am trying to ensure that database contains only capital letters
Can this be specified at the database level so that even if lower case characters are
entered ,  the database stores it as capital

Or do i have to enforce this in my programs ??

A database setting would be much neater

Thanks

Oluwoole
0
Olukay
Asked:
Olukay
1 Solution
 
lcohanDatabase AnalystCommented:
Unfortunately there is no database settings that can enforce that uppercase rule and you will have to add check constraints on each "text" holding column, triggers and trigger functions to convert/populate columns with uppercase instead of what's being sent to the database. Please do a search on google for "questions/102957/postgresql-force-upper-case-for-all-data" in order to get more details/code sample  how to achieve that.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now