File: csv-guess.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 (21 lines) | stat: -rw-r--r-- 511 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
LOAD CSV
     FROM data/track.csv
     INTO postgresql:///pgloader
     TARGET TABLE csv.track

     WITH truncate

   BEFORE LOAD DO
    $$ drop table if exists csv.track; $$,
    $$ create table csv.track (
          trackid      bigserial primary key,
          track        text,
          album        text,
          media        text,
          genre        text,
          composer     text,
          milliseconds bigint,
          bytes        bigint,
          unitprice    numeric
       );
    $$;