File: dbf.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 (12 lines) | stat: -rw-r--r-- 367 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
 
/*
 * The file comes from:
 *
 * http://www.insee.fr/fr/methodes/nomenclatures/cog/telechargement/2013/dbf/reg2013.dbf
 */ 
LOAD DBF
    FROM data/reg2013.dbf with encoding cp850
    INTO postgresql:///pgloader?public.reg2013
    WITH truncate, create table, disable triggers

    CAST column "reg2013"."region" to integer,
         column "reg2013".tncc to smallint;