sed and gist to create sql

eample2_gis_win

#
# create a sql script to create a table in postgres
# First step is extract the header
#
$ head -n 1 campus_dropout.csv > campus_header

#
# look at header
#
$ cat campus_header

# 
# put each column name on a separate line and add sql type
# definition using sed
#
$ sed 's/,/ varchar,\
/g' campus_header > campus_dropout_raw.sql

#
# look at output
#
$cat campus_dropout_raw.sql