On Wed, Feb 6, 2019 at 8:05 AM Pepe TD Vo <pepevo@xxxxxxxxx> wrote: > get another error, "value too long for type character varying(34). How do I know which table How many tables in your schema are defined with a column having a type of "character varying(34)"? To narrow down if >1 you'd need to trace the load script and see at what point it is failing; or change half of them to "text", try again, change some back to varchar(34), try again repeat until only one of them is "text" and that is your culprit. Or just get rid of "varchar(n)" columns, make them all text and, for those were you really want to keep length limits, add explicit constraints. There have been discussions somewhat recently to make the error message itself more helpful but I don't believe anyone is actively working on it. Its better, IMO, to avoid using "varchar(n)" in your schema anyway. More precise check constraints are a better option not the least of which is because they can be named and self-identify with the table to which they are attached. David J.
