pg_duckdb
pg_duckdb copied to clipboard
Better user experience when library is not in shared_preload_libraries
Related to #200. I think there are (at least) two pain points when using the extension, while not putting it in shared_preload_libraries:
- If you call
read_csv/read_parquetyou get an error saying it cannot be executed in postgres. I think this can be fixed by making these functions C functions, then the library will be automatically loaded when you call them. - Setting
duckdb.execution = trueis a no-op. I don't think there's a way to make this experience better, except try to educate people better. Right now the README doesn't mention any of the options to load the library, except for doing "create extension". I think the README should mentionLOAD,session_preload_librariesandshared_preload_libraries.