Skip to main content

Home/ ProGauge SCADA/ Group items tagged postgresql

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Kevin Mershon

[#GRAILS-5302] Postgresql generated SQL should quote table and field names - Grails JIRA - 0 views

jira.grails.org/...GRAILS-5302

grails postgresql hibernate column name capitalization reserved word keyword

shared by Kevin Mershon on 12 Apr 12 - No Cached
  • Any reserved names can be escaped with backticks in the mapping block, e.g. static mapping = { table "`user`" }
Kevin Mershon

DbSettings - 0 views

www.h2database.com/...DbSettings.html

grails gorm postgresql h2 column identifier case sensitive sensitivity join joinTable

shared by Kevin Mershon on 12 Apr 12 - No Cached
  • databaseToUpper Database setting DATABASE_TO_UPPER (default: true). Database short names are converted to uppercase for the DATABASE() function, and in the CATALOG column of all database meta data methods. Setting this to "false" is experimental. When set to false, all identifier names (table names, column names) are case sensitive (except aggregate, built-in functions, data types, and keywords).
  • Kevin Mershon on 12 Apr 12
     
    "Database setting DATABASE_TO_UPPER (default: true). Database short names are converted to uppercase for the DATABASE() function, and in the CATALOG column of all database meta data methods. Setting this to "false" is experimental. When set to false, all identifier names (table names, column names) are case sensitive (except aggregate, built-in functions, data types, and keywords)."
1 - 2 of 2
Showing 20▼ items per page