/* * This test is ported from pgloader 2.x where it was defined as: * * [udc] * table = udc * format = text * filename = udc/udc.data * input_encoding = 'latin1' * field_sep = % * columns = b:2, d:1, x:3, y:4 * udc_c = constant value * copy_columns = b, c, d * */ LOAD CSV FROM inline WITH ENCODING latin1 (d, b, x, y) INTO postgresql:///pgloader?udc ( b , c text using "constant value" , d ) WITH fields optionally enclosed by '"', fields escaped by double-quote, fields terminated by '%' SET client_encoding to 'latin1', work_mem to '12MB', standard_conforming_strings to 'on' BEFORE LOAD DO $$ drop table if exists udc; $$, $$ create table udc ( b integer primary key, c text, d integer ); $$; 1%5%foo%bar 2%10%bar%toto 3%4%toto%titi 4%18%titi%baz 5%2%baz%foo