Re: Mass Import/Generate PKs

That sounds nice and easy...

So, I would do something like 'ALTER TABLE' to generate the PK column? What
would be the best way to populate it? Is there an area of doco I should be
looking at?

Thanks,
Hunter

> From: Peter Eisentraut <peter_e(at)gmx(dot)net>
> Date: Sat, 6 Nov 2004 21:21:25 +0100
> To: Hunter Hillegas <lists(at)lastonepicked(dot)com>, PostgreSQL
> <pgsql-general(at)postgresql(dot)org>
> Subject: Re: [GENERAL] Mass Import/Generate PKs
>
> Hunter Hillegas wrote:
>> I have a CSV file with 400,000 lines of email mailing list
>> information that I need to migrate to a new PostgreSQL database.
>>
>> Each line has all the info I need except a PK (I usually use an int4
>> column for a PK).
>
> You could import the file into PostgreSQL and add a primary key column
> later.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>