mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-06 22:37:02 +02:00
12 lines
367 B
Fish
12 lines
367 B
Fish
/*
|
|
* 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; |