Unanswered: unload all columns including the header
I have a question here. I'd like to unload all rows from a table but when using unload command (as below), it does not include the header name as well (the columns name).
unload to <filename>
select * from <tablename>
alternatively, I tried using select statement to select each column (for a test, table only constst of 3 columns..which is ok). and it does output the column name for each column selected. But, obviously, this is not practical for table with 50 columns for e.g.