Generating valid identifiers

Terry Reedy tjreedy at udel.edu
Thu Jul 26 10:51:21 EDT 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 mailing list