Postgres Pro
Downloads
Home   >   mailing lists

Re: Automatically assuming a specific role after connecting to pg - Mailing list pgsql-general

From Stephen Frost
Subject Re: Automatically assuming a specific role after connecting to pg
Date
Msg-id 20060423134406.GS4474@ns.snowman.net
Whole thread Raw
In response to Automatically assuming a specific role after connecting to pg  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Automatically assuming a specific role after connecting  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
Tree view 
* Florian G. Pflug (fgp@phlo.org) wrote:
> I'd like to be able to connect to postgres, and automatically assume a
> specific role.

Couldn't you just have 'SET ROLE <whatever>' in the user's .psqlrc?  At
least, if that's how they're connecting I think that'd work...

    Enjoy,

        Stephen
Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Automatically assuming a specific role after connecting to pg
Next
From: Dany De Bontridder
Date:
Subject: Postgreql 8.0.3 temporary Table Strange behaviour