Skip to main content

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

  • Dec 2, 2016 6:40 PM UTC
  • 1 reply
  • 9 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
  • Dec 16, 2016 9:06 AM UTC

You can use copy to vertica for file loading. 

What exactly do you want to do?