[postmodern-devel] Capital/mixed-case table/column names?

Matthew Lamari matt.lamari at gmail.com
Thu Nov 1 23:00:27 UTC 2007


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/postmodern-devel/attachments/20071101/4591c874/attachment.html>


More information about the postmodern-devel mailing list