Re: [GENERAL] Length of field names.

> Yeah I guess I didn't explain that very well. Suppose you did
>
> \d test
>
> you'd get
>
> Field | Type | Length
> ------------------------------
> blah | text | var
> number | int2 | 2
> code | char() | 15
>
> [hand-made table :)]
>
> now what is was -badly- trying to say was that is you did a \d of that
> table you'd get:
>
>
> Field | Type | Length
> -----------------------------------
> Field | varchar() | 31
> Type | varchar() | 10
> Length | int2 | 2
>
> [or something like that, I'm guessing the numbers/types]
>
> so a sort of \d on a \d which would have given me the max length of field.
> If I understood Herouth's mail properly, all this information (i.e. catalog
> table) are store as 'hidden' tables in the DBMS. In Oracle it appears
> these are actually 'usable' in SQL statements -if you know their names and
> he was suggesting that the same could be of postgreSQL (I'm sorry if I got
> that all wrong Herouth).

That is \dT, no?

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)