mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
3bcd236de6
Those tests currently only work when a single table is the target of the load, and when this target is explicit in the INTO target clause. More work needs to be done to cover interesting cases like MySQL and SQLite where we want to diff a full database rather than a single table.
15 lines
326 B
Fish
15 lines
326 B
Fish
LOAD CSV
|
|
FROM INLINE with encoding 'ascii'
|
|
INTO postgresql:///pgloader?overflow
|
|
|
|
WITH truncate,
|
|
fields terminated by ',',
|
|
fields not enclosed
|
|
|
|
BEFORE LOAD DO
|
|
$$ drop table if exists overflow; $$,
|
|
$$ CREATE TABLE overflow (id int, f1 text not null) $$;
|
|
|
|
18446744073709551596,a
|
|
12,
|