File: fields-with-periods.load

package info (click to toggle)
pgloader 3.6.9-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 12,040 kB
  • sloc: sql: 32,321; lisp: 14,792; makefile: 439; sh: 85; python: 26
file content (25 lines) | stat: -rw-r--r-- 437 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
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