redshift_tutorial_copy.sql

copy users    from '/tmp/s3/allusers_pipe.txt'  with null as '' delimiter '|';
copy venue    from '/tmp/s3/venue_pipe.txt'                     delimiter '|';
copy category from '/tmp/s3/category_pipe.txt'  with null as '' delimiter '|';
copy date     from '/tmp/s3/date2008_pipe.txt'  with null as '' delimiter '|';
copy event    from '/tmp/s3/allevents_pipe.txt' with null as '' delimiter '|';
copy listing  from '/tmp/s3/listings_pipe.txt'  with null as '' delimiter '|';
copy sales    from '/tmp/s3/sales_tab.txt'      with null as '' delimiter '\t';