Copy Vertica table TO a flat file

Moderator: NorbertKrupa

Post Reply
cvez
Newbie
Newbie
Posts: 1
Joined: Mon Jul 02, 2012 7:08 pm

Copy Vertica table TO a flat file

Post by cvez » Mon Jul 02, 2012 7:29 pm

How do I copy a Vertica table TO a flat file? We use COPY table_name FROM flat file to load a table from a flat file but the reverse COPY table_name TO a flat does not work (unsupported Copy command clause). Thanks !!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Copy Vertica table TO a flat file

Post by JimKnicely » Mon Jul 02, 2012 8:15 pm

Here are links to two previous topics regarding copying data to a flat file:

viewtopic.php?f=18&t=236
viewtopic.php?f=18&t=61

PS: Congratulations on becoming the 100th member to the forums!!!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica SQL”