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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
