duckdb
Verified for current stable LTS
Duckdb Command: Read Csv From Stdin Write To Stdout
Use for read csv from stdin write to stdout with Duckdb. Exact CLI syntax to read csv from stdin write to stdout using Duckdb.
When to use this: Use for read csv from stdin write to stdout with Duckdb.
Command Syntax
cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"Command Breakdown
-c- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to read csv from stdin write to stdout using Duckdb.
Test path: Replace placeholders and run destructive commands in a disposable workspace first.
Flag behavior: Tool version, platform, and shell can change behavior.
Improve This Command
Suggest a correction, safer default, or version-specific note for this entry.
Related Operations
Duckdb Command: Direct Query File View
duckdb <data_source.[csv|csv.gz|json|json.gz|parquet]> -c "< SELECT * FROM file >" Duckdb Command: Query Csv Json Parquet File duckdb -c "<SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'>" Duckdb Command: Query File Using File View duckdb <data_source.[csv|csv.gz|json|json.gz|parquet]> -c "< SELECT * FROM file >" Duckdb Command: Query File Using Sql duckdb -c "<SELECT * FROM 'data_source.[csv|csv.gz|json|json.gz|parquet]'>" Duckdb Command: Read Csv Stdin Write Csv Stdout cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"