| From: | "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Import File |
| Date: | 2005-08-23 16:09:27 |
| Message-ID: | 20050823160927.GA28157@webserv.wug-glas.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-08-23 17:32:48 | Re: Where to get 8.1 beta test version? |
| Previous Message | Bruce Momjian | 2005-08-23 15:38:20 | Re: Where to get 8.1 beta test version? |