question

PaulG215 avatar image
PaulG215 asked

Hi I am trying to copy a csv into postgresql but am getting this error, any help would be great thanks!

CREATE TABLE Opportunities ( OpportunityID varchar(50), DealNumber integer, ProductionAmount integer, DealPurpose char(50), DealStatus char(30), LenderType char(30), OppCreatedDate integer, ApplicationSignedDate integer, ExpectedCloseDate integer );

COPY Opportunities FROM 'C:\Users\Paul\Documents\sql\T_Opportunity.csv' DELIMITER ',' CSV HEADER;

ERROR: relation "opportunities" already exists ********** Error ********** ERROR: relation "opportunities" already exists SQL state: 42P07

sqlpostgresql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.