Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEABCFAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-patches by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef
Next
From: Barry Lind
Date:
Subject: Re: [JDBC] JDBC MetaData getImportedKeys query