Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "Patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef
Date: 2003-01-14 01:43:13
Message-ID: GNELIHDDFBOCMGBFGEFOIEABCFAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> > This lets pg_get_constraintdef display the definitions for UNIQUE and
> > PRIMARY KEY constraints. It's a real shame this wasn't done for 7.3...
>
> Are we now putting the pg_dump functionality into the backend? If not,
> then I don't see the point. You extract this information with relative
> ease from the system catalogs in any form that suits your needs.

Oh, actually I think I might have misunderstood you. pg_get_constraintdef()
already exists, but will only dump FOREIGN KEY statements...

Chris

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Barry Lind 2003-01-14 05:30:51 Re: JDBC MetaData getImportedKeys query
Previous Message Christopher Kings-Lynne 2003-01-14 01:42:12 Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef