ryantuck · August 19, 2016 23:51 · Cbeck527 · Aug 22, 2016
diff --git a/sql_to_csv.sh b/sql_to_csv.sh
 #!/bin/bash

 # executes a .sql file and outputs results to a .csv
 # ./sql_to_csv.sh my_query.sql output.csv

 CONN="psql -U my_user -d my_db"

 # remove all semicolons and comments
 # replace newlines with spaces
 QUERY="$(sed 's/;//g;/^--/ d;s/--.*//g;' $1 | tr '\n' ' ')"
 echo "$QUERY"

 echo "\\copy ($QUERY) to '$2' with csv header" | $CONN > /dev/null
	#!/bin/bash

	# executes a .sql file and outputs results to a .csv
	# ./sql_to_csv.sh my_query.sql output.csv

	CONN="psql -U my_user -d my_db"

	# remove all semicolons and comments
	# replace newlines with spaces
	QUERY="$(sed 's/;//g;/^--/ d;s/--.*//g;' $1 \| tr '\n' ' ')"
	echo "$QUERY"

	echo "\\copy ($QUERY) to '$2' with csv header" \| $CONN > /dev/null