PostgreSQL - copy CSV file WHERE file EXIST

Question

I have this request :

CREATE TEMP TABLE table1 (col1 text, col2 text);
COPY table1 FROM '/path/to/csv/Tab.csv' DELIMITER ',' CSV;

I want that if the file Tab.csv exist it will run the request COPY but if it does not exist it will go to the next request without displaying the error.

Thanks for your feedback.

In what environment are you executing these commands? Does that environment have features to test for a file's existence? — rd_nielsen
– rd_nielsen, Commented Jun 27, 2017 at 1:59

Bryan Newman · Accepted Answer · 2017-06-27 04:44:49Z

2

before the statement, try telling postgres to ignore errors

EXEC SQL WHENEVER SQLERROR CONTINUE

and then when you're done, remember to set it back ;)

answered Jun 27, 2017 at 4:44

Bryan Newman

6313 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL - copy CSV file WHERE file EXIST

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related