mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
47 lines
998 B
Fish
47 lines
998 B
Fish
/*
|
|
* 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
|