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

From Goutam Paruchuri
Subject Re: Mass Import/Generate PKs
Date
Msg-id B2C547DF42419645804F05B54290755ADC7C99@DAYTONEX.oneilinc.net
Whole thread Raw
In response to Mass Import/Generate PKs  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
Yes you can use the copy command. Check for


copy TABLE NAME from 'c:\\bcpdata\\Files\\FILENAME.txt' with delimiter
as '\t'  NULL as '';

When creating a table, use an incremental column (data type is serial).
Hope the above helps.

- Goutam


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> Hunter Hillegas
> Sent: Saturday, November 06, 2004 3:01 PM
> To: PostgreSQL
> Subject: [GENERAL] Mass Import/Generate PKs
>
>
> 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).
>
> If the file were smaller I would probably just use Excel to
> pop in a PK and then just load into the table...
>
> Since Excel chokes on files greater than 65k lines, this won't work.
>
> Is there a way to get this done inside psql for instance? Or
> another route?
>
> Thanks,
> Hunter
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>


Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization
listedin the address. If you have received this communication in error, please contact the sender at O'Neil &
Associates,Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the
intendedrecipient, is strictly prohibited. 


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: [JDBC] Using Postgres with Latin1 (ISO8859-1) and Unicode (utf-8)
Next
From: "Goutam Paruchuri"
Date:
Subject: Re: how to use COPY within plperl