We have autovacuum set up at the database level and don’t want references to autovacuum_enable to appear at the entity level?
The checkbox under “Storage Parameters” was checked by default and added WITH (autovacuum_enabled = true). Unchecking the box, changes it to false but we don’t want it in the DDL script at all.
Additionally, do you have any idea as to when Toad Data Modeler can import PostgreSQL DDL scripts?
TDM generate autovacum parameter in DDL script always, but it is possible make some customization to change this behavior. I can do it for you. Let me know your TDM version and PG versions(Presume PG 9.5) and I'm able to prepare for you tdm package.
Go to Settings-Options-General and Select Expert Mode
Go to Expert Mode - Customization - Import Custom Package
Select Package
Restart TDM
In this package I disable generate autovacuum when is set unchecked checkbox. If you want to disable it every time it easy modification in this package. Just open Package Explorer(Expert Mode), find pacakge “Generator_Autovacuum_PG95” and in this pacakge is located script “PERCodeGeneratorPG95_2”. Doubleclick on this script open script editor and you can modify behavior of generator.
I tried to reproduce your problem with missing import of DDL script, but I’m not successful. I have clear installation and enable only PG 9.5 and I see import DDL PG 9.5 datasource.
I guess your state could have happened after upgrading from the older version. I hope that now it will be OK for you.