Re: very strange behavior.... incomplete query performed

Alain Roger wrote:

There was no error message...hust after few secunds it stop as normaly it should do... but i add -> set_time_limit(0); and it works. adding around 20.000 records to database takes some time :-) around 1:41 minutes. I was thinking that i could be faster... :-(

After doing your iconv stuff, turn it back into a csv file and use \copy like: \copy table from '/path/to/file.csv' Also see http://www.postgresql.org/docs/8.2/interactive/populate.html for some ideas. -- Postgresql & php tutorials http://www.designmagick.com/