`ATTACH` , `search_path` and create `DDL` on current database about duckdb HOT 2 OPEN

Thanks for the report! When creating a table without specifying which database it belongs to, it is created in the first database in the search path. This is equivalent to running USE genai. The remaining entries in the search path are used for reading in case entries are not found in the other catalogs in the search path.

I've opened an issue in the documentation so we can work on clarifying this in the documentation.

from duckdb.

Thanks for the report! When creating a table without specifying which database it belongs to, it is created in the first database in the search path.

Yep, so I searched if there was a kind of . ie. current alias to specify the main database but I did not know how I should call it...

Thanks for the fast answer, that's really cool... and the ATTACH option is so convenient 🪄

from duckdb.