Re: Schema Problem

On Jul 2, 2007, at 4:44 AM, Ashish Karalkar wrote:

> But still the tables are created in the public schema and not in
> xyz schema
>
>
> Postgresql.conf entry:
> serach path =' "$user",public'
>
> tried with setting :
> search path = ' xyz,"$user",public'
> Same result
>
> OR
> search path = ' "$user",xyz,public'
> Same result
>
> OR
> search path = ' "$user",xyz'
> Error:no schema has been selected to create in
>

I'd suggest that your search path command is not quite correct. You
should work that out in psql before trying it in a script. For example:

test=# set search_path to some_schema, "$user", public;
SET

test=# show search_path;
search_path
------------------------------
some_schema, "$user", public
(1 row)

So here any new tables should now be created in "some_schema".

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL