Re: [HACKERS] connection user - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] connection user
Date
Msg-id 6550.922375099@sss.pgh.pa.us
Whole thread Raw
In response to connection user  (Dmitry Samersoff <dms@wplus.net>)
List pgsql-hackers
Dmitry Samersoff <dms@wplus.net> writes:
> Are it is good idea to add to PQsetdb parameters 
>  parameter "USER to conect as" ?

Yup.  PQsetdb() is deprecated these days --- you should really be
calling PQsetdbLogin() or even better PQconnectdb() instead.

> (Or probably there is other way to specify postgres USER, different from
>  pogram euid?)

If you don't provide a user ID parameter, libpq will look first for
an environment variable PGUSER, and failing that use getpwuid(geteuid())
to find out who you are.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Oleg Broytmann
Date:
Subject: Locale patch (Greek locale and koi8-to-win1251 tests)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Really slow query on 6.4.2