Re: [SQL] How to have the types definition table ?

Olivier Ertz wrote:

> Hello,
>
>         how can i see the definition of a table, i mean name column with
> type column, column size ... ?
>
>         Thank you for answering
> --
> ERTZ Olivier - ertz@illite.u-strasbg.fr - Tel 03 88 35 85 87
> ------------------------------------------------------------
>   Etudiant DESS Informatique   |   Stagiaire EOST/ULP-CGS
>    Universite Louis Pasteur    |  Ecole et Observatoire des
>      STRASBOURG - France       |    Sciences de la Terre
> ------------------------------------------------------------
>    World Wide Web : http://dess-info.u-strasbg.fr/~ertz
> ------------------------------------------------------------

>From psql:  \d tablename
ftc=> \d z

Table    = z
+----------------------------------+----------------------------------+-------+

|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+

| a                                | float8                           |
8 |
| b                                | money                            |
4 |
+----------------------------------+----------------------------------+-------+

David Secret
MIS Director
Kearney Development Co., Inc.