File: nofile.load

package info (click to toggle)
pgloader 3.6.10-5
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 12,060 kB
  • sloc: sql: 32,321; lisp: 14,793; makefile: 435; sh: 85; python: 26
file content (22 lines) | stat: -rw-r--r-- 543 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
LOAD CSV
     FROM 'this/file/does/not/exists.csv' WITH ENCODING latin1
          (a, b, c, d, e)
     INTO postgresql:///pgloader?csv.nofile

     WITH truncate,
          skip header = 1,
          fields optionally enclosed by '"',
          fields escaped by double-quote,
          fields terminated by ','

  BEFORE LOAD DO
   $$ create schema if not exists csv; $$,
   $$ create table if not exists csv.nofile
     (
        a      text,
        b      text,
        c      text,
        d      text,
        e      text
     );
   $$;