From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Import textfile as table |
Date: | 2002-10-03 10:04:31 |
Message-ID: | 3D9C6387.31157.93B7C1F@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2 Oct 2002 at 18:01, Michelle Konzack wrote:
> Hello,
>
> I have gotten a 16 MByte textfile with around 27.000 lines of data
> which contains a database with 22 fields which are <TAB> seperated.
>
> How can I import it into a (new) table and or new
> database of pgsql.
You can use \copy in psql. I don't know how would you specify tab as delimeter.
May be you should convert it to some other delimeter like ':' or ',' if tab
does not work.
Get a small chunk of that file. First 100 records or so and experiment.
Otherwise it might get quite irritating..;-)
Bye
Shridhar
--
White's Statement: Don't lose heart!Owen's Commentary on White's Statement:
...they might want to cut it out...Byrd's Addition to Owen's Commentary: ...and
they want to avoid a lengthy search.
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-10-03 10:08:22 | Re: Import textfile as table |
Previous Message | Terry Yapt | 2002-10-03 09:43:53 | is there a pure Win32 Port ? |