I would like to copy all data from a csv into a temporary table in order to update a permanent table in PG Admin. I have tried:
CREATE TEMP TABLE tmp_x AS SELECT * FROM "Schema"."Table" LIMIT 0;
copy tmp_x FROM '\\PATH\TO\CSV\FILE.csv' DELIMITER ',' CSV`
Which tells me "ERROR: could not open file "\PATH\TO\CSV\FILE.csv" for reading: No such file or directory"
So then I try the same code but with a backslash before the before "copy" based on this from another thread How to import CSV file data into a PostgreSQL table?
And then I get a syntax error due to the slash: "ERROR: syntax error at or near "\""
Any help would be appreciated
Thanks
Gaz