pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to have the types definition table ?
2+ messages / 2 participants
[nested] [flat]

* How to have the types definition table ?
@ 1999-07-06 14:32 Olivier Ertz <ertz@illite.u-strasbg.fr>
  1999-07-06 14:51 ` Re: [SQL] How to have the types definition table ? secret <secret@kearneydev.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Olivier Ertz @ 1999-07-06 14:32 UTC (permalink / raw)
  To: pgsql-sql

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 
------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] How to have the types definition table ?
  1999-07-06 14:32 How to have the types definition table ? Olivier Ertz <ertz@illite.u-strasbg.fr>
@ 1999-07-06 14:51 ` secret <secret@kearneydev.com>
  0 siblings, 0 replies; 2+ messages in thread

From: secret @ 1999-07-06 14:51 UTC (permalink / raw)
  To: Olivier Ertz <ertz@illite.u-strasbg.fr>; +Cc: 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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-07-06 14:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-06 14:32 How to have the types definition table ? Olivier Ertz <ertz@illite.u-strasbg.fr>
1999-07-06 14:51 ` secret <secret@kearneydev.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox