COPY INTO table specify columns
13 Mar
2014
13 Mar
'14
12:59 p.m.
Hi,
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?
Thanks!
17 Mar
17 Mar
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
3703
Age (days ago)
3707
Last active (days ago)
1 comments
2 participants
participants (2)
-
Hannes Mühleisen
-
Wei Zhuo