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

From Tom Lane
Subject Re: Schema 'public'
Date
Msg-id 22398.1145425342@sss.pgh.pa.us
Whole thread Raw
In response to Re: Schema 'public'  (Michael Talbot-Wilson <mtw@view.net.au>)
List pgsql-novice
Michael Talbot-Wilson <mtw@view.net.au> writes:
> 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.

That seems to me about as valid as complaining that you shouldn't have
to look at the owner column because you have only one user in your
database.  Or that the type column is useless because you don't have
anything but plain tables in your database.  The \d output is designed
to be useful in typical cases, not custom-tailored for particular
restricted cases.  As Richard suggested, you could make your own view
that shows just what you want ... or hack up psql's describe.c if you're
really determined ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Schema 'public'
Next
From: "Shoaib Mir"
Date:
Subject: Re: Defining the same relation in another database