redshift file1.sql

training=# copy sample_test_stage from 's3://testbucket/Sample_fixed_width.txt' CREDENTIALS 
training-# 'aws_access_key_id=xxxxxxxx; aws_secret_access_key=yyyyyyyyy' fixedwidth 'col1:6,col2:4, col3:11,col4:12,col5:10,col6:8';

INFO: Load into table 'sample_test_stage' completed, 17 record(s) loaded successfully. 
COPY 
training=# select * from sample_test_stage limit 2; 
 col1 | col2 | col3 | col4 | col5 | col6 
--------+------+-------------+--------------+------------+--------- 
 191675 | 01 | 01142013 | 2368183100 | OUNHQEX | XUFQONY 
 191673 | 01 | 01142013 | 2632703881 | PAHFSAP | LUVIKXZ 
(2 rows) 
training=#