Roman Golis wrote:
I am trying to load data into a rather simple table:
CREATE TABLE public.files (
id SERIAL,
idchar CHAR(32) NOT NULL,
content BYTEA,
CONSTRAINT files_pkey PRIMARY KEY(id)
) WITHOUT OIDS;
with this command:
copy files (idchar, content) from '/data/1.dat'
I am trying to load data into a rather simple table:
CREATE TABLE public.files (
id SERIAL,
idchar CHAR(32) NOT NULL,
content BYTEA,
CONSTRAINT files_pkey PRIMARY KEY(id)
) WITHOUT OIDS;
with this command:
copy files (idchar, content) from '/data/1.dat' delimiter '|';
The database