I am using Toad Data Point to generate new tables from CSV files.
The target connection is a Postgresql 11 database.
When it detects alphanumeric columns, the Import Wizard is defaulting to a column type of "varchar(n)" where n is the estimated max text length.
In Postgresql, a Varchar is simply a Text column with a length constraint. It is often preferred to use the Text column type unless the db is being counted on to enforce data lengths.
Is it possible to configure Toad Data Point to instead suggest Postgresql column type of "Text" for all alphanumeric CSV columns instead of "Varchar(n)"?
The workaround is to manually edit each column type from "varchar(n)" to "Text", but I would prefer it to use "Text" automatically.