Getting column names with sqsh -m bcp option enabled?

Question

When I'm using sqsh in interactive mode, sometimes I like to run my query in the following way so I can get it in a nice csv file:

1> select * from Table where Blah=Blah

2> go -m bcp > /file/name/here

The only problem I have is that using the "-m bcp" option does not give me the column names in the output. Any idea how to get those column names in a "clean" way?

Answer 1

There is a CSV display mode in sqsh have you tried that