Re: exporting a table

Andrew Jensen wrote:
> I take you are using HSQL and you know about the select into a text 
> table, just in case.
> 
> I have a test datbase with a table named Table1
> 
> The table has three columns, one is an integer and the others are varchar
> 
> If I execute the following statement
> 
> select * into TEXT "tmp3" from "Table1"
> 
> I end up with the file tmp3.csv in the same directoryt as my ODB file.
> 
> This is the contents
> 
> 0,9999,New Value
> 1,1002,cat
> 2,2001,pigeon
> 3,2002,hawk
> 4,3310,turtle
> 5,3318,snail
> 
> So, now we just have to figure out how to make the ',' turn into a '/t'.

ah - thanks a lot. didn't know any of that.

I can convert the commas simply with a regexp in vi.

thanks,
Kae