"In flight" modification of CSV on efficient CSV -> SQL conversion path
Open
- 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.