fike/load_csv.sh

Created August 14, 2012 21:44

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/fike/3353313.js"></script>
Save fike/3353313 to your computer and use it in GitHub Desktop.

Download ZIP

Loading multiple files csv in postgresql

Raw

load_csv.sh

	#!/bin/sh

	for i in $(ls *.csv)
	do psql -U postgres -c "COPY carga FROM '/tmp/$i' WITH DELIMITER ',' CSV HEADER" test;
	done

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment