Re: Import textfile as table

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.