Re: Feature Request
| От | Jonah H. Harris |
|---|---|
| Тема | Re: Feature Request |
| Дата | |
| Msg-id | 36e682920602200617v104bf777xcf9a80ff0972f0c8@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Feature Request (Adam Witney <awitney@sgul.ac.uk>) |
| Ответы |
Re: Feature Request
|
| Список | pgsql-hackers |
ALTER USER bob SET search_path ...?
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324
On 2/20/06, Adam Witney <awitney@sgul.ac.uk> wrote:
On 20/2/06 1:26 pm, "Peter Eisentraut" <peter_e@gmx.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
В списке pgsql-hackers по дате отправления: