[postmodern-devel] Capital/mixed-case table/column names?
This question may betray a limited understanding of Postmodern or PostGres; but. . . . If possible, how can Postmodern be used to generate queries that can interact with capitalized/mixed-case table and column names? It appears that in postgres, unless double-quoted, a string is converted to lowercase (as with lisp with uppercase). String literals are single-quoted to SQL literals, not double-quoted as appears required for names. Postgres appears to lowercase even symbols containing capitals (e.g. |AbCd|) If no mechanism for mixed-case exists, would the use of mixed-case symbols be an appropriate change to make to PostGres? Thanks, Matt
Hello Matthew, As I understand it, Postgresql converts all function, table, and field names to lowercase. Thus, the case in which Postmodern sends them would be irrelevant. If you have a case where this does make a difference, let me know. Cheers, Marijn
participants (2)
-
Marijn Haverbeke
-
Matthew Lamari