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