/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/fixed-guess.load
36 строк
929 B
Dimitri Fontaine
Implement header parsing for fixed file formats.
07 май 2019, 23:57
07 май 2019, 23:57
b1d55e0
Код
Авторство
О чём код?
LOAD FIXED FROM fixed-guess.dat INTO postgresql:///pgloader TARGET TABLE fixed.guess WITH fixed header SET work_mem to '14MB', standard_conforming_strings to 'on' before load do $$ create schema if not exists fixed; $$, $$ drop table if exists fixed.guess; $$, $$ create table fixed.guess ( QECDPO character varying(3), QECSEM character varying(3), QELSEM character varying(30), QERSEM character varying(15), QENCOM integer, QESCRE smallint, QEACRE smallint, QEMCRE smallint, QEJCRE smallint, QEHCRE integer, QECUCR character varying(10), QESMAJ smallint, QEAMAJ smallint, QEMMAJ smallint, QEJMAJ smallint, QEHMAJ integer, QECUMJ character varying(10), QETOPD character varying(1) ); $$ ;