PostgreSQL COPY Syntax Failure (My issue - PostgreSQL is fine)

39 views Asked by At

I'm sure it is obvious that I am a "NEWB" - gotta start somewhere, right? Having an issue understanding how to implement PostgreSQL COPY as depicted in the image below: PostgreSQL COPY Error

Here's the query I attempted to run:

COPY SqlProject.CovidVaccinations
FROM '/Users/brucebeck/Desktop/RDBMS_Work/ATA_PortfolioProject1/CovidVaccinations.csv'
DELIMITER ','
CSV HEADER;

Query result was "ERROR: schema "sqlproject" does not exist SQL state: 3F000 (Which according to PostgreSQL documentation means basically the same thing. I'm guessing that my COPY statement is missing something PostgreSQL needs.

FWIW, I WAS able to load data into the target table (CovidVaccinations) in the SqlProject schema using pgAdmin 4's Import Data tool. Trouble is, I did not learn exactly how to use the COPY command.

Any guidance the collective could provide would be greatly appreciated.

Cheers!

0

There are 0 answers