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