Start a new topic

Error importing to new PostgreSQL table

[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
1 Comment

[This reply is migrated from our old forums.]

Re: Error importing to new PostgreSQL table
Hi Steve, You can also remove the size on the wizard page where the new table is defined. Best Regards, Hans