Thread: connection user

Are it is good idea to add to PQsetdb parameters parameter "USER to conect as" ?

(Or probably there is other way to specify postgres USER, different frompogram euid?)
Thank you!

---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net

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