blaze / blaze/odo

"In flight" modification of CSV on efficient CSV -> SQL conversion path

Open
#208 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1k
Forks
131
PR merge metrics
No merged PRs in 30d

Description

Right now, I'm in a workshop where folks are learning to use sed with output piped to a fully spelled-out psql CSV bulk load command. This is nice because it doesn't leave intermediate data files laying around.

To do the same with odo, I think I currently need to make a new file. Is there a way I could do something equivalent to the following without simply writing an intermediate file?

```
cat building_violations_sample.csv |
sed 's/, ,/,,/g' |
psql -d training_2015 -c "\COPY building_violations_sample FROM STDIN WITH CSV HEADER;"
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.