cockroachdb / cockroachdb/cockroach
sql cli should support COPY FROM STDIN where SQL is specified with "-e" and STDIN is pure data
Open
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
With psql you can do this:
```
cat data.csv | psql -c "COPY FROM STDIN CSV;"
```
Where there's no SQL or start/end delimiters in the data.csv, just pure data. I believe this is the predominate way datafiles are sent to PG using COPY from the command line. See copyfrom roachtest for a real world example.
Jira issue: CRDB-24865
Contributor guide
Assessment
This issue has not been assessed yet.