Re: [GENERAL] change data type int4 to serial

2007-02-21 Thread Bruno Wolff III
On Wed, Feb 21, 2007 at 11:20:38 -0600, Seb <[EMAIL PROTECTED]> wrote: > > Checking the results in pgadmin, this proceeded fine, but now that I want > to specify the primary and foreign keys in the tables, I see that the > columns needed for this were imported as int4 data type. I would like >

[GENERAL] change data type int4 to serial

2007-02-21 Thread Seb
Hi, I am experimenting a migration of an M$ Access database to postgresql in a Debian GNU/Linux system. Based on some reading, I've approached it as follows: 1. Using mdbtools, export the tables from Access to *.csv files, sanitizing file names and column names. 2. Using unixodbc and GNU R's