trying to copy data from a CSV file and save it in a table with postgresql.
script based on this post
running script in psql with postgresql version 11.6
command used to run:
\i script.sql
script:
create table data
(
col_1 varchar(64)
, col_2 varchar(64)
, col_3 varchar(64)
, col_4 varchar(64)
, col_5 varchar(64)
, col_6 varchar(64)
, col_7 varchar(128)
, col_8 varchar(64)
, col_9 varchar(64)
, col_10 varchar(64)
, col_11 bigint
)
copy data from 'data.csv' with (format csv);
error message:
ERROR: syntax error at or near "copy"
LINE 15: copy data from 'data.csv' with (format csv...
^
also tried another way based on this tutorial
create table data
(
col_1 varchar(64)
, col_2 varchar(64)
, col_3 varchar(64)
, col_4 varchar(64)
, col_5 varchar(64)
, col_6 varchar(64)
, col_7 varchar(128)
, col_8 varchar(64)
, col_9 varchar(64)
, col_10 varchar(64)
, col_11 bigint
)
copy data(col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9, col_10, col_11)
from 'data.csv' delimiter ',' csv header;
error message:
ERROR: syntax error at or near "copy"
LINE 15: copy data(col_1, col_2, col_3, col_4...