I have a lot of text files I need to load into vertica. The first row in the files is a header and I want to avoid loading that info. in the database.
Here is an example of what I am talking about and what I don't want to happen!
Code: Select all
[dbadmin@vert1 ~]$ cat testdata.txt
header1,header2
1,data1
2,data2
[dbadmin@vert1 ~]$ vsql -c "copy testdata from '/home/dbadmin/testdata.txt' delimiter ',';"
Rows Loaded
-------------
3
(1 row)
[dbadmin@vert1 ~]$ vsql -c "select * from testdata;"
t1 | t2
---------+---------
header1 | header2
1 | data1
2 | data2
(3 rows)
Thank you for your time!!!