X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E8F3052A44 for ; Thu, 18 Aug 2005 11:36:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15978-09 for ; Thu, 18 Aug 2005 14:36:19 +0000 (GMT) Received: from web51910.mail.yahoo.com (web51910.mail.yahoo.com [206.190.48.73]) by svr1.postgresql.org (Postfix) with SMTP id E47CB529E7 for ; Thu, 18 Aug 2005 11:36:18 -0300 (ADT) Received: (qmail 32450 invoked by uid 60001); 18 Aug 2005 14:36:22 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=KP34xBQGQWvFxy+PdBVKCOzNbUJgZu7FJLWuN8DIY2uUumbrsYk0/uK56vESGhXGWHtmWraCS9Vzm7YTU47H6m7m8d4ydaUEp80tNgyKZ6TJNlYytoxiLow0Kiww7++WuEQPnXvfO18GxXjLcAXCl2TrfLNsxUn5ZNwGLTkKj5k= ; Message-ID: <20050818143622.32448.qmail@web51910.mail.yahoo.com> Received: from [80.84.141.227] by web51910.mail.yahoo.com via HTTP; Thu, 18 Aug 2005 07:36:22 PDT Date: Thu, 18 Aug 2005 07:36:22 -0700 (PDT) From: Roger Tannous Subject: A Table's Primary Key Listing To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.456 required=5 tests=[AWL=0.082, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200508/141 X-Sequence-Number: 22369 Hi to all, Is there any means to get a list of the Primary Keys (or simply the Primary Key if there's only one :) ) for a given table using an SQL query ? Regards, Roger Tannous. __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail