Rust library for parsing redshift files generated by the UNLOAD command. The UNLOAD command must be executed with the following options: DELIMITER '|' ESCAPE ADDQUOTES
.
```rust
// transform redshift file to csv
// parse redshift file from stdin
let mut redshift_reader = redshift::reader::Reader::new(io::stdin());
// create a writer to stdout
let mut csv_writer = csv::Writer::from_writer(io::stdout());
// write out each record
for row in redshift_reader {
csv_writer.encode(row.values).unwrap();
}
```
The above example is included as an executable redshift2csv
. Usage:
redshift2csv < redshiftfile > redshiftfile.csv