Andrew Humphrey DigiWhale

## README.md

      
        
          
            
              
              1 file
            
          
          
            
              
              1 fork
            
          
            
              
                
                3 comments
              
            
          
            
              
              15 stars
            
          
        
        
          
              
          
          
            
                chriswhong
                / README.md
            
            
              Created
              February 28, 2020 17:55
            
              
                Using ogr2ogr to load a CSV into Postgres
              
          
        
      
        
  
      
    The absolute easiest way to get a CSV into a postgresql table is to use ogr2ogr with AUTODETECT_TYPE=YES.
I learned a while back that this is what cartoDB uses to import your CSV into postgis (with a lot of other parameters added)
ogr2ogr -f PostgreSQL PG:"host=localhost user=postgres dbname=postgres password=password"  docs.csv -oo AUTODETECT_TYPE=YES