Re: Schemas to Search_path

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 ?

Thanks Much!

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, March 09, 2005 4:57 PM
To: Subbiah, Stalin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Schemas to Search_path

"Subbiah, Stalin" <SSubbiah@netopia.com> writes:
> I logged into foodb as foo user and tried to create a table. Bang!
> ERROR:  no schema has been selected to create in. search_path had
> $user, public the default ones, shouldn't the table get created in
> user's authorized schema.

Which one?

Now, if you make the schema name the same as the user name, it will do
what you want --- that's what the $user is for.  If you want some other
schema that happens to belong to that user to be the default, you have
to adjust the normal value of search_path.  (See ALTER USER SET if you'd
like that adjustment to be done for you automatically at each login.)

            regards, tom lane