'Cannot copy a file from a desktop folder to PostgreSQL (ERROR: relation "us_conties_2010" does not exist SQL state: 42P01)

I am using the Copy command to import a file form a desktop folder into a table a have created on PostgreSQL but it ends up being impossible due to the error in the title.

I am running PgAdmin as administrator and the piece of code I used can be found below:]

COPY us_conties_2010
FROM 'C:\Users\my_name\Desktop\practical-sql-master\Chapter_04\us_counties_2010.csv'
WITH (FORMAT CSV, HEADER);

does anyone have an idea to solve this problem?

postgresqlcopypgadmin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions