Skip to content

Instantly share code, notes, and snippets.

@eliangcs

eliangcs/export_import_vertica.sql

Last active August 29, 2015 14:17
Show Gist options
  • Save eliangcs/1708d46d0d58ede7f83f to your computer and use it in GitHub Desktop.
Save eliangcs/1708d46d0d58ede7f83f to your computer and use it in GitHub Desktop.
Download ZIP
Export/import data from Vertica
Raw
export_import_vertica.sql
-- 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