Robert Edwards wrote:
> Or is it possible, over the same connection, to change the database
> user? My understanding of the frontend/backend protocol is that this
> is not allowed.
Not on protocol level, but one level higher.
SET SESSION AUTHORIZATION <user>;
pg_dump uses this frequently. See the docs for more details.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-sql by date
|Next:||From: James Cloos||Date: 2006-09-11 12:04:59|
|Subject: Re: where clause subqueries vs multiple rows results|
|Previous:||From: Markus Schaber||Date: 2006-09-11 10:31:43|
|Subject: Re: on connect/on disconnect|