I've used the syntax below to export a table from Teradata Aster into a csv file:
\o file_name.csv
COPY table_name TO STDOUT WITH DELIMITER ',';
\o
\install file_name.csv
This code creates a csv with data exported from the Aster table. But, it does not contain the header row. The data is large enough that an export through Teradata Studio Express is not viable. Currently, my solution is to manually insert the header in a text editor post COPY
. I'm wondering if there is a way to do this in act?
When you first log into ACT, you will find a welcome screen:
You can use the
\h COPY
to look up the documentation for youCOPY
function. Like so:Here there are no options to copy with headers. So I think you might have to add the headers back after you've copied.