Importing hundreds of CSV's into postgres (non-sequential naming) https://gis.stackexchange.com/questions/132569/loading-multiple-csv-files-into-postgresql-table
Looked at links like this, but it doesn't really make sense to me.  Is there any way anyone could dumb this down for me?  I'm using ubuntu btw.  Thank you!
If the CSV files are in the same directory, a global import can be scripted from  Ubuntu with a bash script like:
cd /path/to/csv-directory
for file in *.csv
do
  psql (add connection options here) &lt;&lt; EOF
\copy MyTableName from $file (format csv)
EOF
done