On 11/06/2019 15.17, Suresh Devarakonda wrote:
Hi,
I am new to the MonetDB and interested to know about its case sensitivity. We noticed that objects are being created in lower case if they are not specified in quotes so it appears to me that default case for objects created in Monet is LOWERCASE. But, we got a requirement that objects should be created in upper case even though they are not specified in quotes in DDL statements. In other words, can we make the default to UPPERCASE for all the objects when they created. Please let us know if that is possible.
Not without a lot of source code changes.
In any case, why this requirement? If you use upper case without quoting in all your queries things should work. The only place where you would get lowercase, I think, is in dump output.