17 Mar
2014
17 Mar
'14
10:27 a.m.
Hi Wei,
On 03/13/2014 01:59 PM, Wei Zhuo wrote:
Couldn't find any info/doc if a list of column names, and order of columns, can be specified when using COPY INTO command. If not possible, is this something relatively easy to implement?
Specifying the columns in a copy into is not supported at the moment. We may add this at some point. You can always copy into a temporary table and create a view or reorganize the layout with the CREATE TABLE mytable AS SELECT ... WITH DATA to bring it in the form you would like.
Hope this helps,
Hannes