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:
