Re: unable to see other schemas besides public - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: unable to see other schemas besides public
Date
Msg-id 47494D58.6060603@timbira.com
Whole thread Raw
In response to unable to see other schemas besides public  (Gabriel Ramirez <gabrielramirez@yahoo.com>)
Responses Re: unable to see other schemas besides public
List 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/

pgsql-bugs by date:

Previous
From: Gabriel Ramirez
Date:
Subject: unable to see other schemas besides public
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #3734: Invalid XML schema output.