Re: Alter session set current_schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Salerno, Vincent" <vincent(dot)salerno(at)lmco(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Alter session set current_schema
Date: 2004-09-11 06:19:16
Message-ID: 7606.1094883556@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Salerno, Vincent" <vincent(dot)salerno(at)lmco(dot)com> writes:
> In Oracle you can log on using OS authentication & then:
> ALTER SESSION SET CURRENT_SCHEMA= <schema name>;

> Is there anyway to do this in PostGres?

I would suppose that "SET search_path" is the right equivalent ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michalis Kabrianis 2004-09-11 06:22:36 Re: [SQL] PL/pgSQL Function Problem
Previous Message Tom Lane 2004-09-11 06:03:30 Re: PL/pgSQL Function Problem