Received: from necker.ac-rouen.fr (smtp.ac-rouen.fr [194.167.110.3]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5JC8Ua44540 for ; Tue, 19 Jun 2001 08:08:30 -0400 (EDT) (envelope-from david.bouriaud@ac-rouen.fr) Received: from ac-rouen.fr (localhost.localdomain [127.0.0.1]) by necker.ac-rouen.fr (8.11.0/8.11.0) with ESMTP id f5JCA0117219 for ; Tue, 19 Jun 2001 14:10:00 +0200 Message-ID: <3B2F4128.D9D38897@ac-rouen.fr> Date: Tue, 19 Jun 2001 14:10:16 +0200 From: David BOURIAUD X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.2.14 i686) X-Accept-Language: fr, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: About primary keys. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/286 X-Sequence-Number: 3549 Hi the list ! Is there a way to get in system tables all the primary keys of a table ? Thanks by advance. P.S. I'm running postgreSQL v7.1.2 on a SuSE 6.4 Linux box. -- David BOURIAUD ---------------------------------------------------------- In a world without walls or fences, what use do we have for windows or gates ? ---------------------------------------------------------- ICQ#102562021