Importing hundreds of CSV's into postgres (non-sequential naming)
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