Received: from nexus.kearneydev.com (IDENT:root@nexus.kearneydev.com [208.136.214.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA32830 for ; Tue, 6 Jul 1999 10:52:18 -0400 (EDT) (envelope-from secret@kearneydev.com) Received: from kearneydev.com (atu.kearneydev.com [208.136.214.93]) by nexus.kearneydev.com (8.8.5/8.8.5) with ESMTP id KAA07504; Tue, 6 Jul 1999 10:51:52 -0400 Message-ID: <37821807.8564B52C@kearneydev.com> Date: Tue, 06 Jul 1999 10:51:51 -0400 From: secret Organization: Kearney Development Co., Inc. X-Mailer: Mozilla 4.51 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Olivier Ertz CC: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] How to have the types definition table ? References: <3782137C.2F5007B0@illite.u-strasbg.fr> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.