Here’s a simple wrapper script that I wrote in bash for bulk loading data into PostgreSQL from csv files. Beware, it also does a code page conversion at the end that you may not want. That part should be parameterized, I just haven’t gotten around to it yet. Link to the download is here 1 [...]
Entries Tagged as 'OS X'
csv2pg — Load a comma separated values file into postgresql
January 22nd, 2010 · No Comments · Linux, OS X
Tags:
xlsx2csv – Excel xlsx (spreadsheetML) to CSV bash script
December 18th, 2009 · 8 Comments · Linux, OS X
Read an MS excel SpreadsheetML document and extracts the data to csv
Tags:
Writing to syslog in a bash script
November 30th, 2009 · No Comments · OS X
Here’s a little snippet to show how to use logger (included with OS/X, don’t know on other platforms) to syslog errors from a bash script.
Tags: