Re: [GENERAL] Script for reading flat file without delimiters

2006-06-29 Thread Tino Wildenhain
Mehdi Aboulkassim schrieb: If I had to write it in java, I wouldn't mail this issue. I somewhat a Neophyte in Postrgres that's why I need your help. I've searched in the netbut I haven't found a script in Plpgsql that can read a file. Can you tell me if we can do this in Plpgsql? No you c

Re: [GENERAL] Script for reading flat file without delimiters

2006-06-29 Thread Michael Fuhr
On Thu, Jun 29, 2006 at 03:10:03PM +0200, Mehdi Aboulkassim wrote: > I have to write a function that takes a flat file name in parameter > and load a table with the file information. Does it matter if this function runs on the server side or in the client? > I think that it has to read the fi

Re: [GENERAL] Script for reading flat file without delimiters

2006-06-29 Thread Tino Wildenhain
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 co

[GENERAL] Script for reading flat file without delimiters

2006-06-29 Thread Mehdi Aboulkassim
Hy everybody,   I have to write a function that takes a flat file name in parameter and load a table with the file information.   I think that it has to read the file line per line and parse each one to retreive each column data.   There is NO DELIMITERS between fields.   Can someone help.