warp icon indicating copy to clipboard operation
warp copied to clipboard

Export data table to Postgres

Open ghost opened this issue 8 years ago • 0 comments

When I try to upload a data table (from CSV) to a newly created Postgres table with the command "write to table in schema public in PostgreSQL database cmdb..." and mark "Modify destination table to fit data", the process stops with "This table does not have a primary key, which is required in order to be able to identify individual rows." How can I then upload a data table to a new database table in PostgreSQL. Additionally , I've not found something where I can declare a column in a CSV table to be "unique" or "primary".

ghost avatar Nov 03 '17 10:11 ghost