Re: [SQL] Adding a Primary Key to an exisiting table

2003-01-02 Thread Bhuvan A
> 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 wa

[SQL] Adding a Primary Key to an exisiting table

2003-01-02 Thread Maly Kaing
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