Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5JDnTa85991 for ; Tue, 19 Jun 2001 09:49:29 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f5JDnIn6031006; Tue, 19 Jun 2001 07:49:18 -0600 Date: Tue, 19 Jun 2001 07:49:18 -0600 From: Roberto Mello To: David BOURIAUD Cc: "pgsql-sql@postgresql.org" Subject: Re: About primary keys. Message-ID: <20010619074918.A30985@cc.usu.edu> References: <3B2F4128.D9D38897@ac-rouen.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3B2F4128.D9D38897@ac-rouen.fr> User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/290 X-Sequence-Number: 3553 On Tue, Jun 19, 2001 at 02:10:16PM +0200, David BOURIAUD wrote: > Hi the list ! > Is there a way to get in system tables all the primary keys of a table ? There's a recipe that is related to that in my Postgres CookBook that you could adapt to your needs: http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36 -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer TAGLINE NO ESPELHO ¤ OHLEPSE ON ENILGAT