Re: Schemas to Search_path

Поиск
Список
Период
Сортировка
От Edmund Bacon
Тема Re: Schemas to Search_path
Дата
Msg-id m3psy733ur.fsf@elb_lx.onesystem.ca
обсуждение исходный текст
Ответ на Re: Schemas to Search_path  ("Subbiah, Stalin" <SSubbiah@netopia.com>)
Список pgsql-admin
Дерево обсуждения 
SSubbiah@netopia.com ("Subbiah, Stalin") writes:

> I created schema name "foo_schema" different from user name "foo".
> However, when I created the schema, I had specified authorization set to
> foo user.
>
> Does that mean, if the owner of the schema and schema name are
> different, then only way, is to set through alter user set or search
> path correct ?
>
There is also ALTER DATABASE foo SET search_path TO schema [, schema]
...

> Thanks Much!

--
Remove -42 for email

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Schon, Gregor"
Дата:
Сообщение: Restoring a Dump with psql on Windows Fails -Password Cannot Be Entered (?)
Следующее
От: Eduardo Mambrilla Martínez
Дата:
Сообщение: How can I recreate the template0 database?