Re: [SQL] How to have the types definition table ? - Mailing list pgsql-sql

From secret
Subject Re: [SQL] How to have the types definition table ?
Date
Msg-id 37821807.8564B52C@kearneydev.com
Whole thread Raw
In response to How to have the types definition table ?  (Olivier Ertz <ertz@illite.u-strasbg.fr>)
List pgsql-sql
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.




pgsql-sql by date:

Previous
From: Olivier Ertz
Date:
Subject: How to have the types definition table ?
Next
From: "Eid, Bilal"
Date:
Subject: Large Objects