/*
 * 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