Re: Script for reading flat file without delimiters

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Mehdi Aboulkassim <mehdi10ab(at)yahoo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Script for reading flat file without delimiters
Date: 2006-06-29 13:25:06
Message-ID: 44A3D4B2.5080601@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mehdi Aboulkassim schrieb:
> Hy everybody,
>
> I have to write a function that takes a flat file name in parameter and
> load a table with the file information.

Which programming languages do you plan to use?

> I think that it has to read the file line per line and parse each one to
> retreive each column data.

probably.

> There is NO DELIMITERS between fields.
>
How can the fields identified then? Fixed size?
You need to provide much more details - otoh,
it should not be too hard with a scripting
language and just some script you write.

Regards
Tino

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-06-29 13:36:57 Re: Script for reading flat file without delimiters
Previous Message Mehdi Aboulkassim 2006-06-29 13:10:03 Script for reading flat file without delimiters