Jim Nasby <Jim.Nasby@bluetreble.com> writes: > What I've had problems with is trying to correlate psql specified > connection attributes with things like DBI. It would be nice if there > was a way to get a fully formed connection URI for the current connection.
Yeah, although I'd think the capability to create such a URI is libpq's province not psql's. Maybe a PQgetConnectionURI(PGConn) function in libpq, and some psql backslash command to access that? Or maybe a nicer API would be that there's a magic psql variable containing the URI; not sure.
proof concept of PQGetConnectionUri and \uri command.
I like the idea, thanks!
missing:
connection options
uri encoding
Attached adds implementation of both. Still missing:
- documentation
Maybe we should provide a bool parameter to this new function so that additional parameters could be ignored. Right now it will print a few default values, that are of no great use anyway:
I don't think we can detect and remove the default values from this output in a reliable way?
This is pretty difficult - any parameter can be important, and hard to identify default values on client side without connect to server side. I don't see any other way, than hold bitmap for identification entered values and default values from the input.
