reformat.load

/*
 * This test is ported from pgloader 2.x where it was defined as:
 *
 * [reformat]
 * table           = reformat
 * format          = text
 * filename        = reformat/reformat.data
 * field_sep       = |
 * columns         = id, timestamp
 * reformat        = timestamp:mysql:timestamp
 *
 */


LOAD CSV
     FROM inline (id, timestamp)
     INTO postgresql:///pgloader?reformat
        (
          id,
          timestamp timestamptz using (date-with-no-separator timestamp)
        )

     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 reformat; $$,
   $$ create table reformat (
       id integer primary key,
       timestamp timestamp with time zone
      );
   $$;




1|20071119150718
2|20041002153048
3|20060111060850
4|20060111060958
5|00000000000000