Создаем таблицу, копируем файл в ОС
create table cabinet.buff_kpgz(
id integer,
date_time_create character varying(128),
date_time_chnage character varying(128),
code_kpgz character varying(128),
name character varying(1000),
prnt_kpgz character varying(1000),
s_desc character varying(4000),
okpd character varying(128),
okpd2 character varying(128),
code_mer character varying(128),
is_need_be_ref character varying(128),
is_stand_position character varying(128),
is_gov_expert character varying(128),
to_repair character varying(128),
obj_type character varying(128),
project character varying(128)
);
select * from cabinet.buff_kpgz
в Dbeaver
COPY cabinet.buff_kpgz FROM '/home/kpgz.csv' DELIMITER ';' CSV HEADER encoding 'windows-1251';
create table cabinet.buff_kpgz(
id integer,
date_time_create character varying(128),
date_time_chnage character varying(128),
code_kpgz character varying(128),
name character varying(1000),
prnt_kpgz character varying(1000),
s_desc character varying(4000),
okpd character varying(128),
okpd2 character varying(128),
code_mer character varying(128),
is_need_be_ref character varying(128),
is_stand_position character varying(128),
is_gov_expert character varying(128),
to_repair character varying(128),
obj_type character varying(128),
project character varying(128)
);
select * from cabinet.buff_kpgz
в Dbeaver
COPY cabinet.buff_kpgz FROM '/home/kpgz.csv' DELIMITER ';' CSV HEADER encoding 'windows-1251';
Комментариев нет:
Отправить комментарий