| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | David BOURIAUD <david(dot)bouriaud(at)ac-rouen(dot)fr> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: About primary keys. |
| Date: | 2001-06-19 13:49:18 |
| Message-ID: | 20010619074918.A30985@cc.usu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikael Kjellstrm | 2001-06-19 14:04:38 | How to check if a table exists from functions. |
| Previous Message | Sergey E. Volkov | 2001-06-19 13:01:40 | Re: Passing cursor between functions in embedded SQL |