Received: from lady.axian.com (lady.axian.com [38.252.131.138]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA30386 for ; Thu, 20 Apr 2000 19:51:20 -0400 (EDT) (envelope-from michaelk@axian.com) Received: from TestClient (Test_Client [38.252.132.181]) by lady.axian.com (8.9.1a/8.9.1) with SMTP id QAA06465; Thu, 20 Apr 2000 16:51:13 -0700 (PDT) From: "Michael S. Kelly" To: "Larry ganga giri" , Cc: Subject: RE: How to do this in pgsql? Date: Thu, 20 Apr 2000 16:52:09 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal X-Archive-Number: 200004/235 Hi Larry, I'm something of a newbie to PostgreSQL myself, but I just happened to be reading the section in Bruce Momjian's book that discusses how to display a table's structure in psql. The command is "\d ". The user-defined types will be in chapter 16, which is, as yet, unwritten. But the Programmer's Guide seems to discuss this topic. If you haven't looked at Momjian's book yet, I highly recommend you download a copy. http://www.postgresql.org/docs/awbook.html Good luck, -=michael=- -----Original Message----- From: Larry ganga giri [mailto:linuxfan@england.com] Sent: Wednesday, April 19, 2000 9:08 PM To: pgsql-sql-owner+M349@hub.org Cc: pgsql-sql@postgresql.org Subject: How to do this in pgsql? Hi, I need to *Describe the table structure. Tried Desc as in oracle. But it failed. *Create an user-defined type in pgsql. can anybody help me pleez? thanks, Larry. __________________________________________________________________ Get your own free England E-mail address at http://www.england.com