[This topic is migrated from our old forums. The original author name has been removed]
When importing data from a CSV file to a new PostgreSQL table with a column of type "TEXT" defined, it appears that the underlying table DDL statement includes the column length. This is invalid for a PostgreSQL text column and results in the following error:
ERROR: type modifier is not allowed for type "text"
I worked around the problem by copying the DDL text from the log window to a SQL commander tab and removing the column length. This allowed me to create the table.
Product: DbVisualizer Pro 9.0.6
Build: #1928 (2013/04/14 09:44)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_45
Java Vendor: Apple Inc.
OS Name: Mac OS X
OS Arch: x86_64
OS Version: 10.8.3
almost 5 years ago
[This reply is migrated from our old forums.]
Re: Error importing to new PostgreSQL table
You can also remove the size on the wizard page where the new table is defined.