Re: Feature Request

ALTER USER bob SET search_path ...?

On 2/20/06, Adam Witney <awitney(at)sgul(dot)ac(dot)uk> wrote:
>
> On 20/2/06 1:26 pm, "Peter Eisentraut" <peter_e(at)gmx(dot)net> wrote:
>
> > Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes:
> >> Hey,
> >>
> >> This might not be much, but can there maybe be a future feature for
> >> having a shortcut to "set search_path='schema-name';"
> >> similiar to \c dbname ??
> >
> > pei=# \set X 'set search_path = '
> > pei=# :X public;
> > SET
> > pei=# show search_path;
> > search_path
> > -------------
> > public
>
> That seems quite handy to know! can these be saved anywhere such that I
> don't have to run the \set <...> command every session?
>
> Thanks
>
> Adam
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324