"ATTACH DATABASE" Fails but Drop Works

[HamidHosseiniUniMelb]

Hi everyone,

When we drop a duckdb file in "https://sql-workbench.com/", it shows the embeded tables. However, when we use "ATTACH DATABASE '/resources/my_spatial_db.duckdb' AS mdb;", it is shown in the databases window but with no tables. We are looking forward to the query behind the drop process.

We really appreciate your guidance.

Thanks

[tobilg]

Thanks for the issue report. Just to understand better, the path /resources/my_spatial_db.duckdb is a file path on your local machine?

If so, this will Not work because the browser doesn’t have direct access to the filesystem on your machine. You either have to Drag & Drop a file, or use the file Dialog to upload the file into the browser’s scope.