| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Michael Talbot-Wilson <mtw(at)view(dot)net(dot)au> |
| Cc: | Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Schema 'public' |
| Date: | 2006-04-19 05:18:50 |
| Message-ID: | 20060419051850.96025.qmail@web31802.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)view(dot)net(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-04-19 05:31:09 | Re: Schema 'public' |
| Previous Message | Michael Talbot-Wilson | 2006-04-19 05:10:36 | Re: Schema 'public' |