redshift_copy_default.sql

dev=# create table pior.event_stage (
    event_id CHAR(56), 
    user_id VARCHAR(20), 
    session_id VARCHAR(32),
    ts timestamp NOT NULL DEFAULT sysdate
) ;
CREATE TABLE

dev=# insert into pior.event_stage VALUES ('event_123', 'user_123', 'session_123');
INSERT 0 1

dev=# select * from pior.event_stage;
                         event_id                         | user_id  | session_id  |             ts             
----------------------------------------------------------+----------+-------------+----------------------------
 event_123                                                | user_123 | session_123 | 2014-10-07 21:19:44.736245