mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
26 lines
437 B
Fish
26 lines
437 B
Fish
LOAD FIXED
|
|
FROM inline
|
|
(
|
|
"CHARS.LETTERS" from 0 for 3,
|
|
"CHARS.NUMBERS" from 3 for 3
|
|
)
|
|
INTO postgresql:///pgloader?fixed
|
|
(
|
|
"CHARS.LETTERS",
|
|
"CHARS.NUMBERS"
|
|
)
|
|
|
|
WITH truncate
|
|
|
|
BEFORE LOAD DO
|
|
$$ drop table if exists fixed; $$,
|
|
$$ create table fixed (
|
|
"CHARS.LETTERS" char(3),
|
|
"CHARS.NUMBERS" char(3)
|
|
);
|
|
$$;
|
|
|
|
abc123
|
|
def456
|
|
ghi789
|