Skip to content

Instantly share code, notes, and snippets.

@spara
Created February 6, 2012 17:27
Show Gist options
  • Select an option

  • Save spara/1753496 to your computer and use it in GitHub Desktop.

Select an option

Save spara/1753496 to your computer and use it in GitHub Desktop.
adding create table and closing paren
#
# Finish the script by adding a create table statement
# using your favorite editor or on the command line.
# Note that this version of sed does not have inplace
# editing, so a tmp file is used
#
$ sed '1s/^/CREATE TABLE campust_dropout_raw( /' campus_dropout.sql > tmp
$ sed '$s/$/ varchar);/' tmp > campus_dropout.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment