Postgres Pro
Downloads
Home   >   mailing lists

Adding a Primary Key to an exisiting table - Mailing list pgsql-sql

From Maly Kaing
Subject Adding a Primary Key to an exisiting table
Date
Msg-id Pine.SGI.4.44L.01.0301021605420.3404871-100000@irix2.gl.umbc.edu
Whole thread Raw
Responses Re: Adding a Primary Key to an exisiting table
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: empty arrays
Next
From: "Brian Walker"
Date:
Subject: NULLL comparison in multiple column unique index