Re: [SQL] raw data into table process

2007-08-22 Thread Steve Midgley
Hi, I'm not sure if you have access to a scripting language (like perl or ruby) but my experience is that if you transform the source text file into a secondary text file that postgres copy can read natively/directly into the data formats you want, the copy command will move everything into

[SQL] raw data into table process

2007-08-21 Thread novice
I am trying to record the following entries into a table. I'm curious to know if there's an efficient/effective way of doing this? This entries come from an ancient datalogger (note: separated by space and uses YY/MM/DD format to record date) Plain file sample.dat 3665 OK BS