Import File

From: "Rodrigo Africani" <rafricani(at)fotinisystems(dot)com(dot)br>
To: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Import File
Date: 2005-08-23 14:47:57
Message-ID: 006601c5a7f1$a804f020$5501a8c0@Rodrigo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to import a sequence txt file.
The file has fix columns ... i.e the first 10 positions is the primary key ...
The comand copy need a delimitier but the file is seq without a delimitier.
I look in the manual but i don't won't if it is possible.
My problem is the file is very large ... > 1G and I don't have a lot of memory to change the file and put delimitiers.

Tanks
--
Rodrigo Africani

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Miller 2005-08-23 14:53:33 Re: Question about Foreign key constraint causes "costly
Previous Message Michael Fuhr 2005-08-23 14:35:48 Re: How to limit database size