Skip to content

Instantly share code, notes, and snippets.

@eliangcs
Last active August 29, 2015 14:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eliangcs/1708d46d0d58ede7f83f to your computer and use it in GitHub Desktop.
Save eliangcs/1708d46d0d58ede7f83f to your computer and use it in GitHub Desktop.
Export/import data from Vertica
-- Export
\a -- Disable alignment
\t -- Disable column header
\o output.txt -- Set output filename
SELECT * FROM table; -- Select the data to export
-- Import
COPY table FROM '/path/to/output.txt' DELIMITER '|';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment