Re: Schema 'public' - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Schema 'public'
Date
Msg-id 20060419051850.96025.qmail@web31802.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Schema 'public'  (Michael Talbot-Wilson <mtw@view.net.au>)
List pgsql-novice
In you wanted, you could create a custom view that queried the pg_catalog schema to give to the
same results without the schema column.

--- Michael Talbot-Wilson <mtw@view.net.au> wrote:

> On Tue, 18 Apr 2006, Richard Broersma Jr wrote:
>
> > Just curious,  What "thing" is tell you that "it" is in the public schema?
>
> For example...
>
> protoaddress=> \d
>                  List of relations
>   Schema |         Name         |   Type   | Owner
> --------+----------------------+----------+-------
>   public | address              | table    | qdu
>   public | address_key_seq      | sequence | qdu
>   public | country              | table    | qdu
>   public | country_k_seq        | sequence | qdu
>   ...
>
> etc. etc.
>
> I don't want to know.
>


pgsql-novice by date:

Previous
From: Michael Talbot-Wilson
Date:
Subject: Re: Schema 'public'
Next
From: Tom Lane
Date:
Subject: Re: Schema 'public'