mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
60 lines
1.4 KiB
Fish
60 lines
1.4 KiB
Fish
/*
|
|
* This test is ported from pgloader 2.x where it was defined as:
|
|
*
|
|
* [simple_tmpl]
|
|
* template = True
|
|
* format = text
|
|
* datestyle = dmy
|
|
* field_sep = |
|
|
* trailing_sep = True
|
|
*
|
|
* [simple]
|
|
* use_template = simple_tmpl
|
|
* table = simple
|
|
* filename = simple/simple.data
|
|
* columns = a:1, b:3, c:2
|
|
* skip_head_lines = 2
|
|
*
|
|
* # those reject settings are defaults one
|
|
* reject_log = /tmp/simple.rej.log
|
|
* reject_data = /tmp/simple.rej
|
|
*/
|
|
|
|
LOAD CSV
|
|
FROM inline (a, c, b, trailing)
|
|
INTO postgresql:///pgloader?simple (a, b, c)
|
|
|
|
WITH truncate,
|
|
skip header = 2,
|
|
fields optionally enclosed by '"',
|
|
fields escaped by double-quote,
|
|
fields terminated by '|'
|
|
|
|
SET client_encoding to 'latin1',
|
|
datestyle to 'dmy',
|
|
work_mem to '12MB',
|
|
standard_conforming_strings to 'on'
|
|
|
|
BEFORE LOAD DO
|
|
$$ drop table if exists simple; $$,
|
|
$$ create table simple (
|
|
a integer primary key,
|
|
b date,
|
|
c text
|
|
);
|
|
$$;
|
|
|
|
|
|
|
|
|
|
This is a stupid useless header like you sometime find in CSV files
|
|
id|data|date|
|
|
1|some first row text|2006-11-11|
|
|
2|some second row text|13/11/2006|
|
|
3|some third row text|12-10-2006|
|
|
4|\ |2006-10-4|
|
|
5|some fifth row text|2006-5-12|
|
|
6|some sixth row text|10/7/6|
|
|
7|some null date to play with||
|
|
8|"with embedded""quote"||
|