Received: from h00a024ee7419.ne.mediaone.net (h00a024ee7419.ne.mediaone.net [24.91.215.71]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0Q2Yrq44757 for ; Thu, 25 Jan 2001 21:34:53 -0500 (EST) (envelope-from ron.peterson@yellowbank.com) Received: from yellowbank.com (IDENT:yrp001@h00a024ee7419.ne.mediaone.net [24.91.215.71]) by h00a024ee7419.ne.mediaone.net (8.11.1/8.11.1) with ESMTP id f0Q2Yes04691; Thu, 25 Jan 2001 21:34:40 -0500 Message-ID: <3A70E240.64FC7006@yellowbank.com> Date: Thu, 25 Jan 2001 21:34:40 -0500 From: Ron Peterson Organization: Yellowbank X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.4.0-test10 i586) X-Accept-Language: en MIME-Version: 1.0 To: "Mike D'Agosta" CC: pgsql-sql@postgresql.org Subject: Re: Is there anything like DESCRIBE? References: <94n93j$2j6j$1@news.tht.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/373 X-Sequence-Number: 1046 Mike D'Agosta wrote: > > Hi, > > I have a number of empty tables and I want to get the column names and > data types with an SQL statement. I want to do this procedurally, not > interactively (so I can't use \d in psql). Postgres doesn't > support DESCRIBE... is there any other way to do this? src/tutorial/syscat.source has some examples you might like to study. -Ron-