Generating valid identifiers
tjreedy at udel.edu
Thu Jul 26 16:51:21 CEST 2012
On 7/26/2012 8:26 AM, Laszlo Nagy wrote:
> I have a program that creates various database objects in PostgreSQL.
> There is a DOM, and for each element in the DOM, a database object is
> created (schema, table, field, index and tablespace).
> I do not want this program to generate very long identifiers. It would
> increase SQL parsing time and don't look good. Let's just say that the
> limit should be 32 characters.
If I controlled all the component names, I would try to limit their
lengths so that the sum of lengths was limited to the limit.
Terry Jan Reedy
More information about the Python-list