change data type int4 to serial

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: change data type int4 to serial
Date: 2007-02-21 17:20:38
Message-ID: 87zm77ctqx.fsf@patagonia.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 package RODBC, import the tables to an empty
database in postgresql; i.e. create a database in postgresql, read the
tables into R for cleaning up mbdbtools' job and let RODBC import the
tables into postgresql, specifying the data type for
date/time/timestamp columns.

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
these to be automatically sequenced, so need them to be 'serial'. Going
into "properties" for these columns in pgadmin, the 'serial' option is not
available in the "data type" pull-down menu. Is this not possible? Can
the 'serial' data type be specified during import. Thanks in advance.

Cheers,

--
Seb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-02-21 17:35:08 Re: postgresql vs mysql
Previous Message Robert Fitzpatrick 2007-02-21 17:19:41 Expanding the crosstab function to extra rows