duckdb
Verified for current stable LTS
Duckdb Command: Run Query Keep Shell Open
Use for run query keep shell open with Duckdb. Exact CLI syntax to run query keep shell open using Duckdb.
When to use this: Use for run query keep shell open with Duckdb.
Command Syntax
duckdb <path/to/dbfile> -cmd "<SELECT DISTINCT * FROM tbl>"duckdb <path/to/dbfile> -cmd "<SELECT DISTINCT * FROM tbl>"Command Breakdown
-cmd- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to run query keep shell open 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 From Stdin Write To Stdout cat <path/to/source.csv> | duckdb -c "<COPY (FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT CSV, HEADER)>"