Postgres Pro
Downloads
Home   >   mailing lists

Import File - Mailing list pgsql-general

From Rodrigo Africani
Subject Import File
Date
Msg-id 006601c5a7f1$a804f020$5501a8c0@Rodrigo
Whole thread Raw
Responses Re: Import File  (Michael Fuhr <mike@fuhr.org>)
Re: Import File  ("A. Kretschmer" <akretschmer@despammed.com>)
Re: Import File  (Brent Wood <b.wood@niwa.co.nz>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: How to limit database size
Next
From: Tom Lane
Date:
Subject: Re: Question about Foreign key constraint causes "costly sequential scans"?