-
-
Notifications
You must be signed in to change notification settings - Fork 528
/
searchindex.js
1 lines (1 loc) · 25.8 KB
/
searchindex.js
1
Search.setIndex({docnames:["bugreport","index","intro","pgloader","pgloader-usage-examples","ref/archive","ref/copy","ref/csv","ref/dbf","ref/fixed","ref/ixf","ref/mssql","ref/mysql","ref/sqlite","ref/transforms","tutorial/csv","tutorial/dBase","tutorial/fixed","tutorial/geolite","tutorial/mysql","tutorial/quickstart","tutorial/sqlite","tutorial/tutorial"],envversion:53,filenames:["bugreport.rst","index.rst","intro.rst","pgloader.rst","pgloader-usage-examples.rst","ref/archive.rst","ref/copy.rst","ref/csv.rst","ref/dbf.rst","ref/fixed.rst","ref/ixf.rst","ref/mssql.rst","ref/mysql.rst","ref/sqlite.rst","ref/transforms.rst","tutorial/csv.rst","tutorial/dBase.rst","tutorial/fixed.rst","tutorial/geolite.rst","tutorial/mysql.rst","tutorial/quickstart.rst","tutorial/sqlite.rst","tutorial/tutorial.rst"],objects:{},objnames:{},objtypes:{},terms:{"000s":[19,21,22],"001s":[19,22],"003s":[21,22],"006s":[19,21,22],"007s":[19,22],"008s":[21,22],"010s":[16,22],"01234562008052115182300left":9,"01234567892008052011431250firstlin":9,"012s":[18,19,21,22],"013s":[17,21,22],"014s":[21,22],"016s":[21,22],"017s":[21,22],"018s":[19,21,22],"019s":[15,17,18,22],"021s":[21,22],"023s":[19,21,22],"025s":[21,22],"027s":[21,22],"031s":[21,22],"032s":[21,22],"033s":[21,22],"034s":[21,22],"035s":[19,22],"036s":[19,22],"037s":[19,22],"039s":[15,22],"040s":[21,22],"041s":[19,22],"043s":[21,22],"052s":[21,22],"058s":[15,19,22],"059s":[19,22],"068s":[19,22],"070s":[19,21,22],"071s":[16,19,21,22],"073s":[19,22],"077s":[21,22],"080s":[19,22],"0d0":14,"0x0":14,"0x27":7,"105s":[21,22],"111s":[21,22],"12345678902008052208231560anoth":9,"128mb":[0,12,19,22],"12mb":[12,15,19,22],"130s":[19,22],"135s":[19,22],"136s":[19,22],"14mb":[6,9],"150s":[19,22],"154s":[19,22],"160s":[21,22],"167s":[16,22],"16mb":[11,13,21,22],"16t08":[19,22],"1m8":[18,22],"2013_gaz_113cds_nat":[4,20,22],"205s":[19,22],"208s":[19,22],"20t16":[21,22],"214s":[19,22],"227s":[19,22],"228s":[19,22],"236s":[19,22],"247s":[19,22],"254s":[19,22],"268s":[19,22],"279s":[21,22],"303s":[19,22],"313s":[21,22],"332s":[18,22],"365s":[19,22],"390s":[18,22],"402s":[19,22],"42p16":[21,22],"476s":[21,22],"494s":[17,22],"497s":[19,22],"499s":[17,22],"502s":[19,22],"527s":[19,22],"539s":[19,22],"547s":[19,22],"583s":[19,22],"592s":[18,22],"648s":[19,22],"658s":[16,19,22],"669s":[21,22],"692s":[18,22],"743s":[18,22],"877s":[21,22],"892s":[19,22],"906s":[16,22],"964s":[19,22],"9n8v8pw54t1gngfff0lj16040000gn":[16,17,18,22],"boolean":[11,12,14,19,22],"byte":[3,6,9,11,14],"case":[1,2,3,4,11,12,13,19,20,21,22],"char":[11,12,13,15,17,22],"default":[1,3,7,10,14,19,22],"enum":[12,14],"export":[3,11],"final":[1,4,18,20,22],"float":[11,12,13,14,18,22],"function":[1,3,12],"import":[3,4,15,16,17,18,19,20,21,22],"int":[12,14],"long":[17,22],"new":3,"null":[5,6,7,9,12,14,17,18,19,22],"public":[0,11,12],"return":[12,14],"short":0,"static":3,"switch":[3,4,20,22],"true":14,"try":[3,4,20,22],"var":[16,17,18,22],"while":[3,4,12,18,19,20,22],AND:[5,12,18,22],And:[1,18,22],For:[0,3,4,12,14,20,22],INTO:[0,5,6,7,8,9,10,12,15,16,17,18,22],Its:[21,22],NOT:[3,12],One:3,That:[2,3,7,12,14,18,22],The:[2,3,4,5,6,7,8,9,10,11,12,13,14,20],Then:[3,5],USING:[3,18,21,22],Use:[0,3,4,6,7,8,9,10,12,13],Useful:3,Using:[3,18,22],WITH:[0,1,5,15,16,17,18,19,22],_list:12,abil:3,abl:[2,3,12],about:[1,4,12,20,22],abov:[3,4,6,7,9,11,12,15,20,22],absolut:[3,6,7,9],accept:[2,3,5,6,7,8,9,10,11,12,13,21,22],access:7,accomod:3,accumul:[3,11],achiev:[11,12],action:12,activ:[3,12],actor:[12,19,22],actual:[3,14,18,22],add:[19,21,22],added:11,addit:3,address:[6,8,10,18,19,22],administr:[16,22],advanc:[3,19,21,22],aen66609:3,after:[2,6,7,9,12,13],again:[2,3,4,7,12,13,19,20,22],against:[3,4,5,6,7,8,9,10,12,13,20,21,22],al0100124abbevil:[17,22],al0100460adamsvil:[17,22],al0100484addison:[17,22],al0100676akron:[17,22],al0100820alabast:[17,22],al0100988albertvil:[17,22],al0101132alexand:[17,22],aland:[4,20,22],aland_sqmi:[4,20,22],album:[6,21,22],all:[2,3,4,5,6,7,8,9,10,11,13,14,19,20,21,22],allow:[2,3,5,6,7,8,9,10,11,12,13,15,17,19,21,22],alon:[19,22],alreadi:[3,12,13],also:[3,4,5,7,9,12,13,18,20,21,22],alter:[3,6,7,8,9,10,13,21,22],amend:[11,12,13],amount:3,ampersand:3,ani:[2,3,6,7,9,11,12,13,14],anoth:3,anyth:[3,14],anywai:3,api:[19,22],app:0,appdata:3,appear:[3,12,13],append:12,appli:[3,5,6,7,9,11,12,13,14],applic:12,application_nam:0,appoint:13,appropri:[18,22],arbitrari:3,architectur:[2,3],archiv:[1,3,16,17,18],areacod:[5,18,22],argument:[1,4,6,7,9,12,20,22],around:[3,19,22],arrai:14,arrang:9,artist:[21,22],ascii:[6,7],ask:12,aspect:2,assess:12,associ:12,astext:14,attach:[12,13],attempt:3,augment:12,auto_incr:[12,19,22],autom:[2,3],automat:[7,9,11,12,13,19,22],avail:[2,3,12],awai:[3,19,22],awat:[4,20,22],awater_sqmi:[4,20,22],back:[12,13],backslash:[0,7],backward:3,bad:3,baddata:0,bar:14,base:[3,4,12,20,22],basic:3,batch:1,battl:[4,20,22],becaus:[3,4,12,20,22],been:[3,5,12,13,15,16,17,18,19,21,22],befor:[0,2,5,6,7,8,9,10,11,12,13,15,16,17,18,19,21,22],begin:[3,6,7,9,12,14],behavior:[3,12],behaviour:[1,7,12],being:[3,4,12,13,20,22],below:[3,7,9],benefit:[16,19,21,22],best:7,better:3,between:[0,4,6,7,9,20,22],bigint:[4,6,12,13,15,20,22],bigseri:[6,12,19,22],binari:[3,11,12,13,14],bit:[3,11,12,14],blank:[5,7,9,17,18,22],blob:[12,13],block:[5,7,18,22],blocks_ip4r_idx:[5,18,22],both:[3,7,9,12,19,22],bracket:[7,9],breath:12,brows:[15,16,17,18,19,21,22],buffer:[4,20,22],bug:1,build:[11,12,13,19,21,22],built:[7,12],bypass:[3,4,20,22],bytea:[11,12,13,14],calendar:[19,22],can:[2,3,4,5,6,7,9,11,12,14,15,16,17,18,19,20,21,22],canada:[15,22],capabl:[16,19,21,22],care:[0,4,6,7,8,9,10,12,13,14,19,20,21,22],cascad:[11,12,13,18,22],cast:[1,3,4,19,20,22],categori:[19,22],caus:3,censu:[17,22],chanc:12,chang:[3,11,12],charact:[3,4,6,7,9,12,13,14,20,22],characterist:3,charset:11,check:[12,13],checkout:3,chinook:[21,22],chinook_sqlite_autoincrementpk:[21,22],chinookdatabas:[21,22],choic:[19,22],circuit:[19,22],citi:[5,17,18,19,22],claus:[1,5,6,7,8,9,10,11,12,13,14,19,22],clean:[12,13],client:[3,11],client_encod:[15,16,22],clob:13,close:3,code:[3,6,7,12],cog:[4,8,16,20,22],col:1,collid:3,colon:3,column:[3,4,7,9,12,13,15,17,18,19,20,22],com:[0,12,18,19,21,22],come:3,comma:[3,7,9,11,12,13,15,22],command:[1,6,7,8,9,10,11,12,13,14,20],comment:[19,21,22],commerci:[19,22],common:[1,11,12,14],commonli:[4,20,22],compat:3,compil:[3,14],complet:[3,19,21,22],complex:[3,12],compon:[3,12],compos:[6,9],compress:4,comput:3,concurr:[3,12,21,22],condit:[7,12],conf:[3,11],config:3,configur:[3,11],confus:3,connect:[2,4,11,12,20,22],connstr:3,consid:3,consist:[3,18,22],consol:3,constraint:[3,6,7,8,9,10,11,12,13,19,21,22],construct:12,constructor:[19,22],constructorresult:[19,22],constructorstand:[19,22],contain:[0,2,3,4,5,6,7,8,9,10,12,13,18,20,21,22],content:[1,4,5,15,17,18,19,20,22],context:[3,11,12,13],continu:[1,3],control:[3,13],convers:[8,10,12,13],convert:[7,9,12,14],cope:[3,12,14,19,22],copi:[1,2,3,7,8,9,10,12,13,14,19,21,22],copyright:[4,20,22],could:[3,4,7,9,20,22],count:3,countri:[5,18,19,22],coupl:[3,14,17,22],cours:[6,8,10,18,22],cover:[3,12,14],creat:[0,3,4,5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22],createdb:[4,19,20,21,22],creation:[12,13],criteria:12,critic:3,cross:3,csv:[0,1,2,3,5,18],curl:[4,20,22],current:[3,4,5,7,9,11,12,13],current_timestamp:[19,22],custom:[3,11,12,13,19,21,22],cut:3,dai:[2,7,9],dash:[3,4,20,22],dat:[2,3],data:[1,2,3,4,5,6,9,11,12,13,14,19],databas:[1,2,3,4,15,18,19,20,21,22],dataset:[18,22],datasourc:[21,22],datatyp:[12,14,18,22],date:[7,9,11,12,13,14,19,22],datetim:[11,12,13,19,22],datetime2:11,db3:3,dba:3,dbase:[1,3],dbf:[1,2,3,5,6,10,12,16],dbname:[3,7,8,11],dbo:11,dbpath:3,ddl:12,decim:[9,11,12],declar:12,decod:14,decompress:3,defin:[3,6,7,8,9,10,12,13,15,16,17,18,19,21,22],definit:[3,4,11,12,13,19,20,21,22],delai:0,delimit:[3,6],denot:[6,7],depend:[2,3,5,11,12],describ:[2,3,6,7,9,12,15,16,19,21,22],descript:[0,2,7,9],detail:[3,11,12,15,16,17,18,19,21,22],determin:[3,12],dev:[12,15,16,17,18,19,21,22],develop:3,dialect:[12,19,22],did:[3,16,17,21,22],didn:3,differ:[0,2,3,12,14],difficulti:12,digit:[3,7,9,14],dim:[0,5,13,15,16,17,18,19,21,22],dir:3,direct:[4,20,22],directli:[2,3,18,22],directori:[3,5,6,7,9],disabl:[3,6,7,8,9,10,12,13],discov:[4,20,22],discoveri:[3,11,13],distribut:12,district:4,districts_longlat:[4,20,22],divid:12,doc:[3,12,14,17,22],document:[2,3,4,6,14,20,22],doe:[3,19,21,22],doesn:[11,12],doing:[12,13,19,22],dollar:3,domain:3,don:[3,12],done:[3,6,7,8,9,10,11,12,13,18,19,21,22],dot:[3,14],doubl:[3,4,5,6,7,9,11,12,13,15,18,20,22],down:[3,4,20,22],downcas:[12,13],download:[4,5,13,16,17,18,19,20,21,22],drawback:3,driven:[4,20,22],driver:[1,14,19,22],driverstand:[19,22],drop:[0,6,7,9,10,11,12,13,15,17,18,19,21,22],dry:3,dsl:[2,3],dynam:[3,12,18,22],each:[3,7,9,12,13,17,18,22],easi:[0,12,20,22],easier:3,edit:[15,16,17,18,19,21,22],effect:[12,13],either:[2,3,4,6,7,9,10,11,12,13,19,20,22],elaps:14,els:[3,14],email:0,embed:[21,22],emit:3,employe:[21,22],empti:[3,6,7,9,12,14,19,21,22],enabl:[3,6,7,8,9,10,12,13],enclos:[0,3,5,7,9,15,18,22],encod:[1,3,5,7,9,13,14,17,18,22],end:[3,6,7,9,12,13,14,18,19,22],endipnum:[5,7,18,22],engin:[11,12],enjoi:2,enough:[3,12,14],ensur:[4,11,12,13,20,22],enter:[3,9],entir:[4,12,20,22],entri:14,enumer:12,env:3,environ:[2,3,4,11,12,13,20,22],equal:3,equival:[3,4,20,22],ergast:[19,22],erron:3,error:[2,3,15,16,17,18,19,21,22],escap:[0,3,4,5,7,15,18,22],etc:[3,21,22],europ:10,evalu:12,even:[12,13],ever:3,everi:2,exact:[5,6,7,9,12],exampl:[0,3,5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,22],excel:[16,22],except:[3,12],exclud:[19,22],exclus:7,execut:[4,5],exist:[0,3,4,5,6,7,8,9,10,11,12,13,15,17,18,19,20,21,22],exit:3,expand:[3,4,5,20,22],expect:[0,2,3,7,8,9,10,11,12,14,19,21,22],explain:0,explan:11,explicit:3,explicitli:12,express:[5,6,7,9,11,12],ext:3,extens:[0,3,5,18,22],extern:11,extra:[3,4,12,20,22],extract:[16,17,18,22],f1db:[19,22],facil:3,facilit:[15,16,17,18,19,21,22],fact:[19,22],fail:[3,12],fals:14,familiar:3,fashion:3,fast:3,faster:3,feasibl:[4,20,22],featur:[2,3,12],feed:3,feedback:3,fetch:[2,3,6,8,10,12,13,16,17,18,19,21],field:[0,1,3,4,5,8,10,12,13,15,18,20,22],figur:[12,13],file:[1,2,3,5,7,8,10,11,12,13,14,15,18,19],filemak:[16,22],filenam:[3,5,6,7,8,9,10,17,18,22],fill:[2,3],fillfactor:12,film:[12,19,22],film_actor:[19,22],film_categori:[19,22],film_list:[12,19,22],film_text:[19,22],filter:[11,12,13,15,22],finali:[19,22],find:[3,6,7,9,11,12,16,17,18,22],fip:[17,22],fips_cod:[17,22],first:[3,4,5,6,7,9,12,17,20,22],fit:[3,4,20,22],fix:[1,2,3,5],fledg:3,flexibl:[3,12],flight:11,fly:[2,3,12,18,22],folder:[16,17,18,22],follow:[0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,20,22],foo:[0,4,12,14,18,20,22],forc:[3,12],foreign:[4,6,7,8,9,10,11,12,13,19,20,21,22],fork:2,form:[3,12,14],format:[1,2,4,5,7,8,10,14,16,17,18,20,22],former:3,found:[3,4,6,7,8,9,10,11,12,13,14,15,16,18,19,20,21,22],framework:12,free:[18,22],freetd:11,french:[16,22],friendli:3,from:[0,1,2,14,15,16,17,18,21],full:[2,3,12,17,18,22],fulli:[2,3],gazett:[17,22],gazetteer2000:[17,22],gener:12,genr:[6,21,22],geo:[17,22],geographi:11,geoid:[4,20,22],geoip:[18,22],geolit:[1,5,7],geolitec:[5,7,18,22],geolitecity_csv:[18,22],geoloc:[18,22],geometr:12,get:[3,5,7,11,12,13,14,15,22],getenv:3,gist:[5,18,22],git:3,github:[3,21,22],give:[2,19,22],given:[2,3,4,5,6,7,9,12,14,17,18,19,20,21,22],global:[3,11],globalaccount:11,gmt:10,goal:2,good:[3,21,22],gov:[17,22],grammar:3,great:[2,12,13],greater:12,green:2,grow:3,guard:12,guc:3,guc_nam:3,guess:[4,20,22],gunzip:[4,20,22],had:[19,22],handl:[3,12,21,22],happen:[3,4,12,20,22],has:[3,4,5,12,13,15,16,17,18,19,20,21,22],have:[0,2,3,4,7,12,13,19,20,21,22],header:[3,4,5,6,7,9,15,18,20,22],help:[0,3,4,21,22],here:[3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22],hex:14,hexadecim:[6,7,9],hh12:[7,9],hh24:[7,9],hierarchyid:11,histor:[19,22],historiq2013:[4,16,20,22],hold:12,host:[3,4,11,12,16,19,20,21,22],hostnam:3,hour:[7,9],how:[2,3,4,9,12,15,18,20,22],hstore:0,html:[3,12,14,17,22],http:[3,5,6,8,10,12,13,14,15,16,17,18,19,21],human:3,ibm:[3,10],idea:12,identifi:[0,3,12,13],idx_66873_sqlite_autoindex_playlisttrack_1:[21,22],idx_oid:12,ignor:[6,7,8,9,10,12,13],imag:3,impact:3,implement:[2,3,7,9,11,12,14],imposs:12,includ:[0,3,4,7,18,19,20,21,22],index:[1,3,4,5,7,11,12,13,17,18,19,20,21,22],info:3,inforamt:4,inform:[12,16,19,20,21,22],ini:3,inlin:[0,3,6,7,9,12],input:[0,2,3,4,6,7,9,14,15,18,20,22],inse:[4,8,16,20,22],insid:[6,7],inspir:3,instal:[12,13,19,21,22],instanc:[3,11],instead:[18,22],instruct:[5,6,7,8,9,10,11,12,13],integ:[9,12,13,14,18,22],integr:2,intend:[12,13],interact:14,interest:14,intern:[11,12],intervent:2,intptlat:[4,20,22],intptlong:[4,20,22],introduc:[3,7,11,12,13],introduct:1,invalid:[6,7,8,9,10,12,13],inventori:[19,22],invoic:[13,21,22],invoicelin:[21,22],involv:12,ip4:14,ip4r:[5,7,18,22],iprang:[5,7,18,22],ipv4:[3,18,22],isn:[3,12],iso:[5,7,18,22],isol:3,issu:[6,7,8,9,10,12,13],its:[2,3,4,8,10,12,15,16,17,18,19,20,21,22],itself:[3,6,7,11,16,17,22],ixf:[1,3],join:[18,22],json:3,just:[3,4,7,12,13,20,22],keep:[7,12],kei:[0,3,4,6,7,8,9,10,11,12,13,18,19,20,21,22],kept:[3,12],keyword:[7,9,12],kick:12,kind:[2,3,4,20,22],kingdom:[15,22],know:[2,3,7,9,12],known:[3,12],label:12,lack:[11,14],land:[17,22],languag:[2,3,19,22],laptim:[19,22],larg:3,last:[3,12],lastest:[18,22],lastfm_tag:13,lat:[17,22],later:[3,4,20,22],latest:[5,18,22],latin1:[15,16,17,22],latitud:[5,18,22],ldm:[17,22],learn:3,least:12,leav:[3,19,22],left:[3,7,9,12],length:[3,9,17,22],lerocha:[21,22],less:12,let:[16,17,19,21,22],letter:3,level:[2,3,5,12,16,22],lib:11,libpq:3,light:[18,22],like:[3,12],lile:11,limit:[1,3,7,9,11,13],line:[1,4,5,6,7,9,14,17,20],link:5,lisp:[3,11,12,14],list:[3,6,7,8,9,10,11,12,13,16,22],listen:11,liter:14,live:2,load:[0,1,2,11,12,13,14,19],loc_nam:[17,22],local:[3,4,5,6,8,10,20,22],localaccount:11,localhost:[0,3,4,7,8,12,19,20,22],locat:[3,5,10,16,17,18,21],locationnam:[17,22],locid:[5,7,18,22],lock:7,log:[2,3,15,16,17,18,19,21,22],logfil:3,longblob:12,longitud:[5,18,22],longtext:12,look:3,lot:12,machin:3,mai:[3,4,6,7,8,9,10,11,12,13,14,19,20,21,22],main:[3,18,19,22],maintenance_work_mem:[7,11,12,13,19,21,22],make:[3,21,22],man:[4,20,22],manag:[2,3,21,22],mani:[3,6,7,9,12],manner:9,manual:[1,2],map:[12,17,22],master:[21,22],match:[3,4,5,6,7,9,14,17,18,19,20,22],materi:[19,22],max:[3,12],maximum:[3,12,13],maxmind:1,mayb:[4,20,22],mean:[4,12,15,20,22],meant:[2,3],media:6,mediatyp:[21,22],mediumblob:12,mediumint:12,mediumtext:12,memori:[3,12],mess:12,messag:[3,19,21,22],met:12,meta:[8,10,12,13,16,19,21,22],metadata:[2,12,13],method:[3,4,8,16,20,22],methodolog:2,metrocod:[5,18,22],microsecond:[7,9],middl:3,might:[3,4,5,6,7,12,13,20,22],migrat:[1,21],million:[18,22],millisecond:[6,7,9],min:[3,12],mind:3,minimum:3,minut:[7,9],miss:3,mix:3,mode:[3,7,12],model:[3,7,9],modern:[16,22],modif:12,modul:1,moment:5,monei:11,month:[7,9],more:[4,5,11,16,17,20,21,22],most:[0,3,4,19,20,22],motor:[19,22],mrd:[19,22],mssql:[3,11],much:3,multipl:[12,21,22],multipli:3,must:[2,3,4,5,6,7,8,9,10,11,12,13,14,20,22],mustach:1,mysql:[1,2,3,11,14],mysql_host:12,mysql_pwd:12,mysql_tcp_port:12,name:[0,3,4,5,6,7,8,9,10,14,15,16,17,18,19,20,21,22],nativ:3,natur:[21,22],nchar:13,nchat:11,necessari:[3,4,14,20,22],need:[0,2,3,4,7,12,13,14,15,16,17,18,19,20,21,22],net_read_timeout:12,net_write_timeout:12,netloc:3,network:[3,4,20,22],never:3,newdb:[4,20,22],newer:3,night:2,nil:[5,14,18,22],nomenclatur:[4,8,16,20,22],non:[3,5,19,22],none:3,nor:[3,11,12],notat:3,note:[1,4,5,12,13,15,16,17,18,19,20,21,22],notic:[3,4,20,22],now:[4,12,19,20,21,22],nsitra:10,nul:14,number:[3,6,7,9,11,12,13,14],numer:[3,6,7,9,11,12,13],nvarchar:[11,13],object:[12,13],obtain:12,occur:3,offer:[16,18,22],often:[14,15,22],oid:[12,19,21,22],old:[3,4,20,22],omit:[3,12],onc:[3,5,6,7,8,9,10,12,13,19,22],one:[0,3,4,5,7,9,11,12,20,22],ones:[3,12],onli:[2,4,5,6,7,9,14,15,17,19,20,22],onlin:[3,15,16,17,18,19,21,22],open:[3,4,20,22],oper:[15,16,17,18,19,21,22],option:[1,2,4,5,14,15,18,19,20,21,22],order:[2,3,7,12],ordinari:7,org:[3,4,14,18,20,21,22],ori:[12,19,22],other:[0,3,7,11,12,13,14,19,22],otherwis:[3,12],ouput:[0,15,18,22],our:[12,15,16,17,18,19,21,22],out:[3,12,13,14],output:[0,3,12,16,17,19,21,22],over:[2,3,4,12,13,19,20,22],overload:[11,12,13,14],overrid:3,overs:3,own:[2,3,14],packag:[3,12,14],pad:[9,17,22],page:[1,4,20,22],pagila:[4,12,20,22],pair:[2,3,18,22],parallel:[1,7],paramet:[3,7,9,12],pari:10,pars:[3,4,6,7,9,10,13,15,16,17,18,19,21,22],parser:[3,7,12],part:[3,7,9,12],partial:1,particular:[3,19,22],pass:3,password:[3,12],past:12,path:[3,13,15,22],pattern:[7,9,11,13],payment:[19,22],per:[3,7,9,12,19,22],percent:3,perform:[1,7],pg_get_keyword:12,pgdatabas:3,pghost:3,pgloader:[0,2,5,6,7,8,9,10,11,12,13,14,19],pgpass:3,pgpassfil:3,pgpassword:3,pgsql:[4,12,18,19,20,21,22],pguser:3,pick:3,piggyback:11,pipe:[3,4,20,22],pitstop:[19,22],place:[3,16,17,22],places2k:[17,22],plai:3,plain:12,playlist:[21,22],playlisttrack:[21,22],pleas:[3,4,11,12,13,20,22],point:[3,5,12,13,14,18,22],popular:[18,22],port:[3,11,12],posit:[9,17,22],possibl:[0,3,4,6,7,8,9,10,12,13,19,20,22],postalcod:[5,18,22],postgr:[4,20,21,22],postgreslq:3,postgresql:[0,1,2,3,4,5,6,7,8,9,10,14,15,16,17,18,20,21],postgresqlpgpass:3,pow:[18,22],pre:[3,4,6,7,8,9,10,12,13,20,22],precis:[4,11,12,13,20,22],prefer:3,prefetch:3,prefix:12,prepar:3,preserv:12,prevent:12,primari:[0,7,11,12,18,19,21,22],print:3,printabl:[6,7],prior:[12,13],privat:[16,17,18,19,21,22],problem:[3,19,22],problemat:0,process:[3,4,5,7,9,12,13,14,18,20,22],produc:14,product:2,project:[2,3,21,22],proper:[3,14],properti:[2,4],protocol:[2,3],provid:[2,3,4,11,12,13,14,16,17,18,19,20,22],psql:3,punctuat:[3,7,9],purpos:[19,22],push:3,qualifi:[3,8,10,19,22],queri:[3,5,12,18,21,22],queue:3,quick:[1,18],quiet:3,quit:[14,15,18,22],quot:[0,3,4,5,6,7,9,10,12,14,15,18,22],race:[19,22],rag:3,rang:[5,7,12,14,17,18,22],rather:[3,12],raw:[2,3,21,22],read:[2,3,6,7,8,9,10,12,15,16,17,18,19,21],readabl:3,reader:[3,7,9,12],readi:[15,16,17,18,19,21,22],real:[3,11,13],reason:3,receiv:14,recent:3,recogn:[4,7,20,22],recommand:0,record:[18,19,22],recreat:[12,13],redund:4,refer:[1,4,11,12,20,22],referenc:[12,13],refman:12,refrain:[11,12,13],refus:3,reg2013:8,regardless:12,regexp:[6,7,9,12],region:[3,5,18,22],regular:[5,6,7,9,11,12],reject:[2,3,19,22],rel:[3,6,7,9],reload:3,remain:3,rememb:14,remov:[7,12,13,14],renam:12,rental:[19,22],replac:3,report:[1,19,21,22],repres:[14,18,22],represent:[6,12,14,18,22],reproduc:1,requir:[3,9,12],reserv:[12,17,22],reset:[12,13,19,21,22],resp:3,respect:[3,12,21,22],respons:3,restrict:3,result:[3,6,7,8,9,10,11,12,13,19],retri:1,reus:12,review:4,rewrit:12,rich:3,right:[3,4,7,9,14,16,17,20,22],root:[3,12,19,22],row:[3,12,13,15,22],rule:[1,3,5,6,7,9,19,22],run:[3,4,5,12,19,20,21,22],runtim:[3,14],sai:3,sakila:[4,12,19,20,22],sales_bi:12,sales_by_stor:12,same:[3,4,5,6,7,8,9,10,11,12,13,20,21,22],sampl:[19,22],sanit:[3,19,22],satisfi:3,scale:12,scenario:3,schedul:2,schema:[1,3,4,5,10,13,18,19,20,21,22],script:3,search:[1,12,14],search_path:[12,19,22],season:[19,22],second:[7,9,14],section:[3,4,11,12,20,22],see:[3,6,7,9,11,12,15,16,17,19,21,22],select:[12,18,19,22],self:[0,3],semi:3,send:3,sens:3,sensibl:12,sent:[3,11,12],separ:[3,4,7,9,11,12,13,14,15,22],sequenc:[12,13,19,21,22],seri:5,serial:[0,12],server:[2,3,11,14],servic:2,session:3,set:[0,5,6,7,9,11,12,13,14,15,16,18,19,21,22],setup:[1,2,3,12],sever:[3,5,6,7,9,12,13,21,22],shorter:[17,22],should:[3,12],show:[3,17,22],side:[3,7,9],sign:[3,7,9,15,22],similar:6,simpl:[3,14,20,22],simultan:3,sinc:14,singl:[2,3,4,6,7,8,9,10,12,18,20],size:[3,9],skip:[3,4,5,6,7,9,12,13,15,18,19,20,21,22],smaller:3,smallint:[11,12,13,19,22],smallmonei:11,smart:3,socket:3,softwar:0,solut:[3,21,22],solv:0,some:[2,3,4,12,14,15,16,17,18,19,20,21,22],someth:3,soon:[2,3],sourc:[0,1,2,4,19,20,21,22],space:[3,7,9],span:3,speak:[16,22],spec:[15,22],special:[6,7,9,11,12,13,18,19,21,22],specif:[1,2,3,4,15,18,19,20,22],specifi:[2,3,4,6,7,9,10,11,12,13,17,20,22],speed:[18,22],spell:[3,5,12],split:12,sql:[1,2,3,4,7,9,12,14,19,20,21,22],sqlite:[1,2,3,14],squar:[7,9],sslmode:[3,12],staff:[19,22],staff_list:[12,19,22],standard:[3,4,6,7,8,9,10,12,13,20,22],standard_conforming_str:[0,6,9,15,22],start:[1,3,9,12,13,15,16,17,18,19,21],startipnum:[5,7,18,22],state:[15,22],statement:[3,12,13],statu:[19,22],stdin:[3,6,7,9],step:[2,3,7,18,22],still:[16,17,22],stop:[3,12],storag:3,store:[19,22],straight:[4,20,22],strea:[7,9],stream:[2,3,4,6,7,9,21],string:[4,6,7,9,11,12,13,14,20,22],sub:1,sublist:[11,12,13],submit:[2,3],subset:3,suitabl:14,summari:[3,19,21,22],suppli:3,support:[1,3,4,5,6,7,8,9,10,11,13,16,20,22],supris:2,syntax:[1,4,6,7,9,20,22],system:[3,12,14,15,16,17,18,19,21,22],tabl:[0,3,4,6,7,8,9,10,14,15,16,17,18,19,20,21,22],tablenam:[3,4,20,22],tabul:[6,7],tag:13,take:[3,4,6,7,9,12,14,19,20,21,22],taken:[0,12,13],talk:3,tapoueh:[4,18,20,22],target:[2,4,6,7,8,9,10,11,12,13,20,22],task:3,tcp:11,tds:11,tdsport:11,techniqu:[4,20,22],telecharg:[4,8,16,20,22],temp:[4,18,20,22],templat:[1,7,9],termin:[0,3,4,5,7,9,15,18,20,22],test1:10,test:[1,3,4,15,16,17,18,19,20,21,22],text:[3,4,6,9,11,12,13,14,15,18,20,22],than:[3,11,12,17,22],thei:[3,7,11,12,13,19,22],them:[3,6,7,9,11,12,13,16,17,22],themselv:[3,7],theoret:12,thi:[0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,22],thing:[3,12],third:2,tho:[19,21,22],those:[0,2,3,4,7,9,11,12,15,19,20,22],though:[0,3,4,20,22],thread:[3,12,19,21,22],threshold:3,tild:3,time:[3,9,12,13,14,15,16,17,18,19,21,22],timestamp:[10,12,13,14],timestamptz:[11,12,13,14,19,22],timezon:10,tinyblob:12,tinyint:[11,12,13,14,19,22],tinytext:12,tmp:[3,5,19,21,22],tmpdir:5,to_char:[7,9],togeth:11,too:[3,12,16,19,22],tool:[2,3,16,19,22],top:5,topic:[19,22],total:[15,16,17,18,19,21,22],town:[17,22],track:[6,21,22],track_ful:6,trackid:6,transform:[1,2,3,18,22],translat:[19,22],trick:[4,20,22],trigger:[3,6,7,8,9,10,12,13,19,21,22],trim:[7,9,14,17,22],truncat:[0,4,6,7,8,9,10,12,13,15,16,18,19,20,21,22],tsv:3,turn:[19,22],tutori:[1,4],tweak:3,two:[2,3,7,12],txt:[4,17,20,22],type:[0,2,3,4,7,8,9,10,11,12,13,14,18,19,20,21,22],typemod:[11,12,13],typic:3,unarch:[4,20,22],under:3,underscor:3,uniqu:[7,12],uniqueidentifi:[11,14],uniquifi:12,unit:[3,15,22],unitpric:6,univers:10,unix:[3,4,14,20,22],unpars:[7,9],unquot:7,unset:[3,5],unsign:[12,14],until:[3,12,13],unzip:[5,16,17,21,22],updat:[19,22],upgrad:3,uri:[3,4,5,12,20,22],url:[3,4,5,6,8,10,12,13,16,17,20,21,22],usag:3,use:[3,4,7,12,14,16,17,18,19,20,21,22],used:[3,4,5,6,7,9,10,11,12,13,14,18,20,22],useful:[3,19,22],user:[3,4,5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22],uses:[2,3,6,19,21,22],using:[2,3,4,5,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22],usp:[4,17,20,22],usual:[3,4,17,20,22],utc:10,utf8:12,utf:[11,13],util:5,uuid:[11,14],valid:3,valu:[0,3,6,7,8,9,10,12,13,14,15,19,22],varbinari:[11,12,14],varchar:[11,12,13,17,22],vari:[15,22],variabl:[3,11,12],variant:[2,3],variou:[2,3],vector:[11,14],verbos:[3,4],veri:[3,18,20,21,22],verifi:12,version:[0,3,4,11,18,20,22],versu:3,view:[1,19,22],wai:[2,3,6,14],wait:3,walk:[6,7,9],want:[3,4,12,18,19,20,22],warn:[3,19,21,22],water:[17,22],webpag:2,websit:[16,22],welcom:11,were:12,what:[7,9,12,13,15,22],whatev:3,when:[3,4,5,6,7,8,9,10,11,12,13,14,17,19,20,21,22],where:[2,3,4,5,6,7,8,9,10,11,12,17,18,20,22],wherea:[3,12],whether:12,which:[3,5,6,7,8,9,10,12,13,14,18,19,21,22],whichev:3,white:3,whitespac:[3,7,9,14,17,22],whole:[2,3,4,5,6,7,9,12,19,20,22],whose:[12,13],width:1,window:3,within:[3,7],without:[2,3,12,13],work:[3,4,11,12,20,22],work_mem:[0,6,7,9,11,12,13,15,19,21,22],worker:[3,12],would:[3,12,19,22],write:[3,4,12,20,22],writer:3,written:14,wtm:[17,22],www:[3,4,8,14,16,17,20,21,22],xml:11,xxx:[19,22],year:[7,9,12,14],yet:12,you:[0,2,3,4,7,11,12,13,14,15,16,17,18,19,20,21,22],your:[2,3,4,11,12,14,18,19,20,21,22],yourself:[4,20,22],yyi:[7,9],yyyi:[7,9],zero:[12,14,19,22],zip:[4,5,6,8,10,13,16,17,18,20,22]},titles:["Reporting Bugs","Welcome to pgloader\u2019s documentation!","Introduction","PgLoader Reference Manual","Pgloader Usage Examples","Loading From an Archive","Loading COPY Formatted Files","Loading CSV data","Loading DBF data","Loading Fixed Cols File Formats","Loading IXF Data","Migrating a MS SQL Database to PostgreSQL","Migrating a MySQL Database to PostgreSQL","Migrating a SQLite database to PostgreSQL","Transformation Functions","Loading CSV Data with pgloader","Loading dBase files with pgloader","Loading Fixed Width Data File with pgloader","Loading MaxMind Geolite Data with pgloader","Migrating from MySQL to PostgreSQL","PgLoader Quick Start","Loading SQLite files with pgloader","PgLoader Tutorial"],titleterms:{"case":0,"default":[11,12,13],"final":5,"function":14,And:3,INTO:3,The:[15,16,17,18,19,21,22],WITH:[3,6,7,8,9,10,11,12,13],about:3,after:3,all:12,alter:[11,12],archiv:[4,5,20,22],argument:3,avail:[4,20,22],batch:3,befor:3,behaviour:3,bug:0,cast:[11,12,13],claus:3,col:9,command:[2,3,4,5,15,16,17,18,19,21,22],comment:3,common:3,complex:4,compress:[20,22],connect:3,continu:2,copi:6,csv:[4,7,15,20,22],data:[7,8,10,15,16,17,18,20,21,22],databas:[11,12,13],dbase:[16,22],dbf:[4,8,20,22],debug:3,decod:12,document:1,driver:11,encod:[11,12],exampl:4,exclud:[11,12,13],execut:3,express:3,fetch:[4,20,22],field:[7,9],file:[4,6,9,16,17,20,21,22],fix:[9,17,22],format:[3,6,9],from:[3,4,5,6,7,8,9,10,11,12,13,19,20,22],gener:3,geolit:[18,22],http:[4,20,22],includ:[11,12,13],indic:1,inform:3,inquiri:3,introduct:2,ixf:10,like:[11,13],limit:12,line:[2,3,19,21,22],load:[3,4,5,6,7,8,9,10,15,16,17,18,20,21,22],locat:[4,20,22],manual:3,match:[11,12],materi:12,maxmind:[18,22],migrat:[2,4,11,12,13,19,20,22],more:3,mustach:3,mysql:[4,12,19,20,22],name:[11,12,13],note:3,onli:[3,11,12,13],oper:3,option:[3,6,7,8,9,10,11,12,13],parallel:3,partial:[11,12,13],perform:3,pgloader:[1,3,4,15,16,17,18,20,21,22],postgresql:[11,12,13,19,22],quick:[20,22],read:[4,20,22],refer:3,regular:3,remot:[4,20,22],renam:11,report:0,reproduc:0,result:[15,22],retri:3,rule:[11,12,13],schema:[11,12],set:3,setup:11,singl:[19,21,22],sourc:[3,5,6,7,8,9,10,11,12,13],specif:[5,6,7,8,9,10,11,12,13],sql:[5,11],sqlite:[4,13,20,21,22],start:[20,22],stdin:[4,20,22],stream:[20,22],string:3,sub:5,support:12,syntax:3,tabl:[1,11,12,13],target:3,templat:3,test:0,through:[4,20,22],transform:[11,12,14],tutori:22,usag:4,view:12,welcom:1,width:[17,22]}})