Skip to main content

I have table name,column order and values. I want to use "copy" instead of "insert"

  • December 2, 2016
  • 1 reply
  • 5 views

rishireddy

I have table name,column order and values. I want to use "copy"  instead of "insert" command. beacuse if we use insert then values will have more restrictions like strings should be in ' ' etc. So is it possible to use copy command for it?

1 reply

ckotsidimos
Forum|alt.badge.img+1
  • Participating Frequently
  • December 16, 2016

You can use copy to vertica for file loading. 

What exactly do you want to do?