Re: psql - better support pipe line - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: psql - better support pipe line
Date
Msg-id CAFj8pRAcj7ofeto1WLFrVgqumZ7XHTc-L0tqRj24vi1528zZ2g@mail.gmail.com
Whole thread Raw
In response to Re: psql - better support pipe line  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql - better support pipe line
List pgsql-hackers
Hi

2015-08-25 17:21 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
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.

missing:

connection options
uri encoding

 

                        regards, tom lane

Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: exposing pg_controldata and pg_config as functions
Next
From: Tom Lane
Date:
Subject: Re: WIP: Rework access method interface