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
postmodern-devel@common-lisp.net