Thread: minor issue: \c without parameter disconnect current user
Hi
I expect so \c without parameters has only informational character. But \c reset user.postgres=# set role to tom;
SET
Time: 0.787 ms
postgres=> select current_user;
+--------------+
| current_user |
+--------------+
| tom |
+--------------+
(1 row)
Time: 0.851 ms
postgres=> \c
You are now connected to database "postgres" as user "pavel".
postgres=# select current_user;
+--------------+
| current_user |
+--------------+
| pavel |
+--------------+
(1 row)
On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > I expect so \c without parameters has only informational character. But \c > reset user. Yeah, I use that feature all the time. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Robert Haas wrote: > On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > > I expect so \c without parameters has only informational character. But \c > > reset user. > > Yeah, I use that feature all the time. And so do the regression tests. I think what Pavel wants is \conninfo. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Alvaro Herrera <alvherre@2ndquadrant.com> writes: > Robert Haas wrote: >> On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: >>> I expect so \c without parameters has only informational character. But \c >>> reset user. >> Yeah, I use that feature all the time. > And so do the regression tests. pg_dump relies on it too, I think. regards, tom lane
2016-10-18 20:11 GMT+02:00 Alvaro Herrera <alvherre@2ndquadrant.com>:
Robert Haas wrote:
> On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> > I expect so \c without parameters has only informational character. But \c
> > reset user.
>
> Yeah, I use that feature all the time.
And so do the regression tests.
I think what Pavel wants is \conninfo.
yes - still something can new for me :)
Pavel
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services