Torenable/monetdb_bulk_load_csv.sql

Last active May 25, 2017 22:39

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/Torenable/4ef7d08b8ed1301dbf338bff2e33ccfc.js"></script>
Save Torenable/4ef7d08b8ed1301dbf338bff2e33ccfc to your computer and use it in GitHub Desktop.

Download ZIP

Bulk load a CSV (with header) to the target table from Mac

Raw

monetdb_bulk_load_csv.sql

	COPY OFFSET 2 INTO target.table FROM '/full/path/to/the.csv'
	USING
	DELIMITERS ',', '\n', '\"'
	NULL AS ''

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