[Question / Feature Request] Updating the postgres connection string without re-scanning

[davidgovea]

Hi there!
Apologies if this is not the right venue - np if you just close it out.

I was wondering if there is a way to update the remote postgresql:// connection string of a scanned view without re-scanning the remote postgres table.

Started using DuckDB to join local data with a production read replica, and it is amazing!
But, I use a short-lived access token, so my postgresql:// connection string changes each day.

Each time it changes, I need to re-scan the tables lookup the catalog info again, which is a pretty slow operation. Would be awesome to just update the url.

I see the strings in the duckDB file using the strings command, but manipulating those directly causes a checksum error on the DB file.

---

I have looked through the information tables and PRAGMA, and have not found a way to access or update the connection string.

Would this be possible?

Thank you so much! This thing is absolute magic :)

[davidgovea]

My bad, I think Discord may be the more appropriate place for this.
https://discord.com/channels/909674491309850675/1087381367421153352

Looks like the information may not be available to end users:

And the possible future improvement of batch catalog lookups would probably alleviate the motivating pain here.