COPY INTO table specify columns
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!
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
participants (2)
-
Hannes Mühleisen
-
Wei Zhuo