Re: unable to see other schemas besides public

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Gabriel Ramirez <gabrielramirez(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: unable to see other schemas besides public
Date: 2007-11-25 10:24:24
Message-ID: 47494D58.6060603@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2007-11-25 12:07:40 Re: BUG #3734: Invalid XML schema output.
Previous Message Gabriel Ramirez 2007-11-25 01:05:24 unable to see other schemas besides public