Adding a Primary Key to an exisiting table

From: Maly Kaing <mkaing1(at)gl(dot)umbc(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Adding a Primary Key to an exisiting table
Date: 2003-01-02 21:15:32
Message-ID: Pine.SGI.4.44L.01.0301021605420.3404871-100000@irix2.gl.umbc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I just exported my MS Access databases into postgres using an ODBC driver,
but the thing is during the export postgres doesn't recognize any of my
primary keys in Access.
Is there any way to alter the tables so that i can make one of my current
fields the primary key? I don't want to drop the column since I already
have data in the table and i don't want to create/drop tables as some of
the documentation suggests since most of my tables have 10+ fields.. any
suggestions??

mtk

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Walker 2003-01-02 23:19:52 NULLL comparison in multiple column unique index
Previous Message Steve Crawford 2003-01-02 19:06:33 Re: empty arrays