I have a PostgreSQL table with existing data, and needs to import all the rows in a CSV file into that table. I am using pgadmin3's Import tool to do the import.
Question: For the newly imported rows, how do I set the values for a specific column (not found in the CSV)? I cant do
UPDATE staging.tablename SET colname = 'somename' the way I could when importing into an empty table. Or is this approach wrong?