Re: Import File
От | A. Kretschmer |
---|---|
Тема | Re: Import File |
Дата | |
Msg-id | 20050823160927.GA28157@webserv.wug-glas.de обсуждение исходный текст |
Ответ на | Import File ("Rodrigo Africani" <rafricani@fotinisystems.com.br>) |
Список | pgsql-general |
am 23.08.2005, um 11:47:57 -0300 mailte Rodrigo Africani folgendes: > 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. There are lot of tools like sed, awk, perl, ... to manipulate a file. This tools can act as a filter, big file aren't a problem. Regards, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
В списке pgsql-general по дате отправления: