Re: psql \d option list overloaded - Mailing list pgsql-hackers

From Tommi Maekitalo
Subject Re: psql \d option list overloaded
Date
Msg-id 200401091119.45778.t.maekitalo@epgmbh.de
Whole thread Raw
In response to Re: psql \d option list overloaded  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-hackers
Hi,

>
> 2) (using information schema ... little better)
>
>     SELECT table_name FROM information_schema.tables WHERE table_schema
> = 'public';
>
> or ...
>
...

I just looked at the information_schema. It is a very nice feature, but 
difficult to use in psql.

I just wanted to see, what I can find here. After trying and rtfm I ended in 
'\d information_schema.*'. I get a very large page wich is quite unreadable. 
'\d' is normally very usable.

It would be better not to show the view-definition.

What if \d on views just show the column, type and attribute. \d+ would show 
the full view-definition.


Tommi

-- 
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de



pgsql-hackers by date:

Previous
From: Dennis Björklund
Date:
Subject: Translations in distributions 2
Next
From: ohp@pyrenet.fr
Date:
Subject: Strand COPY from problem