Read file (.csv) into table with SQL

PHOTO EMBED

Sun Mar 21 2021 16:13:35 GMT+0000 (Coordinated Universal Time)

Saved by @LC117 #sql

Better: COPY {table_name}({table_columns}) FROM STDIN WITH (DELIMITER ',', NULL '?', FORMAT CSV, HEADER TRUE);


Also Possible, but worse: copy r from 'file.csv' WITH NULL AS 'NULL' DELIMITER ';' CSV HEADER;
content_copyCOPY

https://stackoverflow.com/questions/39729901/interpret-several-values-as-null-when-copying-csv-file-in-postgresql-table