Import CSV Only importing first column

I am right-clicking on a table, selecting "Import Data From File" and ensuring that the CSV I've chosen is properly mapped to the table, which it always is because the column order and names are identical.

However, once it's done (with no errors), I select from the table (PostgreSQL) and find that only the first column (an integer column) was imported.

1 comment
Comment actions Permalink

I assume that you add quotes for the "masterId" and "companyName" columns in the DDL preview. Am I right?


Please sign in to leave a comment.