Home > mailing lists

Import File - Mailing list pgsql-general

From	Rodrigo Africani
Subject	Import File
Date	August 23, 2005 14:48:33
Msg-id	006601c5a7f1$a804f020$5501a8c0@Rodrigo Whole thread Raw
Responses	Re: Import File Re: Import File Re: Import File
List	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

From: Michael Fuhr
Date: 23 August 2005, 14:43:47
Subject: Re: How to limit database size

From: Tom Lane
Date: 23 August 2005, 14:57:48
Subject: Re: Question about Foreign key constraint causes "costly sequential scans"?