dbadmin=> CREATE TABLE daily_load (id INT, some_data1 VARCHAR(100), some_data2 VARCHAR(100), file_loaded VARCHAR(200));
CREATE TABLE
dbadmin=> COPY daily_load (id, some_data1, some_data2, file_loaded AS CURRENT_LOAD_SOURCE()) FROM '/home/dbadmin/test*_load.txt';
Rows Loaded
-------------
6
(1 row)
dbadmin=> SELECT * FROM daily_load;
id | some_data1 | some_data2 | file_loaded
----+------------+------------+------------------------------
1 | TEST1 | TEST2 | /home/dbadmin/test1_load.txt
2 | TEST10 | TEST20 | /home/dbadmin/test1_load.txt
3 | TEST100 | TEST200 | /home/dbadmin/test1_load.txt
4 | TEST3 | TEST4 | /home/dbadmin/test2_load.txt
5 | TEST30 | TEST40 | /home/dbadmin/test2_load.txt
6 | TEST300 | TEST400 | /home/dbadmin/test2_load.txt
(6 rows)
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
