Command Line

Search Shortcut cmd + k | ctrl + k

Documentation / Guides / Troubleshooting

Command Line

On Linux and macOS, DuckDB v1.5.0 has a known issue that the command line client does not interpret piped scripts (#21243).

To demonstrate the problem, create a test.sql file:

echo "SELECT 42 AS x;" > test.sql

Piping the file to the DuckDB 1.5.0 CLI client does not run the script:

duckdb < test.sql
# does not run the script

To work around this, add | cat to the end of the call:

duckdb < test.sql | cat

┌───────┐
│   x   │
│ int32 │
├───────┤
│    42 │
└───────┘

If you are piping from a file, you can also use the -f argument:

duckdb -f test.sql

┌───────┐
│   x   │
│ int32 │
├───────┤
│    42 │
└───────┘