Re: unable to see other schemas besides public

From: Gabriel Ramirez <gabrielillo(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: unable to see other schemas besides public
Date: 2007-11-25 18:43:04
Message-ID: 4749C238.3080807@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Euler Taveira de Oliveira wrote:
> Gabriel Ramirez wrote:
>
>> so seems if one don't specified the schemaname.objects to list the
>> database don't return them, or maybe I'm missing a step after creating
>> the schema and objects to be able to list them.
>>
> This is not a bug. You need to set your schema in the search_path [1].
>
> [1]
> http://www.postgresql.org/docs/8.3/static/ddl-schemas.html#DDL-SCHEMAS-PATH
>
>

thanks that resolved my problem.

regards,

Gabriel

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Steve Langasek 2007-11-25 20:50:30 Re: Test suite fails on alpha architecture
Previous Message Peter Eisentraut 2007-11-25 12:07:40 Re: BUG #3734: Invalid XML schema output.