On Wednesday, 26 September 2018 13:41:28 UTC+1, themadmurph wrote:
> I've got a model which was originally in ASE for production. I need to convert to PG but some of the table names are being truncated. I don't know if this is an issue with the pg9.5 driver (I'm using PG10, where I can create the full length table names).
> Is there a way in PD16.5 to configure maximum length on the table name when it is generated?
Yes there is.
Open your physical model, make sure you have the current DBMS set to a PG-compatible one. I'm sure you already have this; just mentioning for completeness.
Choose "Tools \ Model Options" from the main menu, then in the dialog that opens up choose "Table" from under the "Naming Convention", then go to the "Code" tab.
The "Maximum length" setting is there.
And everything else you always wanted but were afraid to ask :-)