Horton

Re: Importing Large Amounts of Data

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Denis Perchine" <dyp@perchine.com>, <pgsql-hackers@postgresql.org>
Date: 2002-04-15T09:15:31Z
Lists: pgsql-hackers 
> On Monday 15 April 2002 03:53, Christopher Kings-Lynne wrote:
> > BTW, instead of:
> >
> > CREATE UNIQUE INDEX bigone_pkey ON bigone (rec_no);
> >
> > do:
> >
> > ALTER TABLE bigone ADD PRIMARY KEY(rec_no);
>
> I am sorry, could you please elaborate more on the difference?

They have the same _effect_, it's just that the first sytnax does not mark
the index as the _primary_ index on the relation.

Chris