OGR2OGR is my primary tool for loading spatial data to PostGIS databases. It's useful because it can process many data formats and has enough functionality and speed to get the job done. It's command line. Some people love command line, but I'm not really a fan of committing syntax to memory, so here are some useful flags and options for OGR2OGR tasks. The basic command to load a shapefile looks like this: ogr2ogr -f "PostgreSQL" PG:"dbname='databasename' host=' addr ' port=' 5432 ' user=' x ' password=' y '" shapefile_name.shp This will load a shapefile to the default schema on the database. You can add options to the command for additional functionality. It's usually not important what order you put the options in the command, but the option's values go after the option. If there are spaces in the filename, you need to put double quotes around the filename and extension. Progress -progress Th...