21 Jan
2009
21 Jan
'09
3:48 p.m.
On Wed, Jan 21, 2009 at 04:34:26PM +0100, Stefan Manegold wrote:
On Wed, Jan 21, 2009 at 10:11:40AM -0500, dariuszs wrote:
Is there any way to copy flat file into the table not using delimiters?
I'm now aware that SQL standard covers such functionality, let alone how is should work.
My guess is that the OP wants something like the following pseudo code: q <- DB.prepare "INSERT INTO tbl (id,txt) VALUES (10,$1);" DB.execute q [OS.readFile filename] i.e. read the contents of a file and bung the whole thing into a single attribute in a single tuple. Not sure though. Dariuszs, any chance of a more verbose explanation? -- Sam http://samason.me.uk/