Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 30437475E43 for ; Thu, 22 Aug 2002 19:14:55 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id CEB55475E03 for ; Thu, 22 Aug 2002 19:14:54 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 01CA43819D3; Thu, 22 Aug 2002 19:14:53 -0400 (EDT) From: Lee Harr X-Newsgroups: comp.databases.postgresql.sql Subject: Re: sql statement to give functionality of \d tablename? Date: Thu, 22 Aug 2002 23:14:53 +0000 (UTC) Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 10 Message-ID: References: <1030007114.22469.0@iris.uk.clara.net> Reply-To: missive@hotmail.com X-Complaints-To: news@hub.org User-Agent: slrn/0.9.7.3 (FreeBSD) To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/413 X-Sequence-Number: 9259 In article <1030007114.22469.0@iris.uk.clara.net>, Philip Rudling wrote: > Is the an SQL statement that can be used from within a program that will > give the output of \d command? Like the describe command in MySQL's version > of SQL? > There is a flag to psql which will show you the sql from the backslash commands. I believe it is -E, but check the manpage.