What happens?

Exported database using the following command:
EXPORT DATABASE '20221115' (FORMAT CSV, HEADER TRUE, FORCE_QUOTE *);

Attempting to import the database gives the following error:
Error: Binder Error: Unrecognized option for CSV reader "force_quote"

If I edit load.sql and remove FORCE_QUOTE '*' from the COPY statements then the import completes successfully.

To Reproduce

Export database using the following command:
EXPORT DATABASE '20221115' (FORMAT CSV, HEADER TRUE, FORCE_QUOTE *);

Attempt to import the export into a new database (file or in-memory) using:
IMPORT DATABASE '20221115';

OS:

WIndows 11 21H2 (22000.1219 x64)

DuckDB Version:

v0.6.0 2213f9c

DuckDB Client:

CLI

Full Name:

Gurpreet Kang

Affiliation:

N/A

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree