X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 63DB9D1B475 for ; Thu, 18 Dec 2003 20:49:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82861-07 for ; Thu, 18 Dec 2003 16:49:05 -0400 (AST) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id C5F50D1B561 for ; Thu, 18 Dec 2003 16:48:58 -0400 (AST) Received: (qmail 20896 invoked by uid 506); 18 Dec 2003 20:48:59 -0000 Received: from unknown (HELO limacorp.com) (66.161.164.36) by garbanzo.limacorp.com with SMTP; 18 Dec 2003 20:48:59 -0000 Message-ID: <3FE2128E.8050808@limacorp.com> Date: Thu, 18 Dec 2003 15:48:14 -0500 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: [Fwd: Quick Question Please] Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/265 X-Sequence-Number: 11771 OOPS! This group is quick and sharp. I was not specific enough with my need. Sorry to clog your email. Was is the SQL syntax to return table names programatically ? thanks again for a quick hand, Terry -------- Original Message -------- Subject: [ADMIN] Quick Question Please Date: Thu, 18 Dec 2003 15:30:41 -0500 From: Terry Hampton To: pgsql-admin@postgresql.org All, Seem to be having a brain lock. What is the method or syntax to return a list of column names for a given table name ? many thanks for your quick help, Terry -- Terry L. Hampton Program Manager LimaCorp, LLC. www.limacorp.com 513.587.1874 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend -- Terry L. Hampton Program Manager LimaCorp, LLC. www.limacorp.com 513.587.1874