Postgres Pro
Downloads
Home   >   mailing lists

Re: Mass Import/Generate PKs - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Mass Import/Generate PKs
Date
Msg-id 200411062121.25708.peter_e@gmx.net
Whole thread Raw
In response to Mass Import/Generate PKs  (Hunter Hillegas <lists@lastonepicked.com>)
Responses Re: Mass Import/Generate PKs
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: Report Generation
Next
From: Troels Arvin
Date:
Subject: Re: Trying to get postgres to use an index