I think that Vertica can import RFC-4180 compliant CSV files, maybe with the help of a user defined function.
My
problem is that I want to export RFC compliant CSV files out of Vertica for import to another database (Postgres, which claims to be able to read RFC CSV).
I have text fields which may contain tabs, new lines, commas, quotes, etc. All the characters that might normally be used as record or field separators
I have managed to export to another Vertica instance by setting the separators to unusual values (see https://community.vertica.com/vertica/topics/how_to_dump_data_to_native_file_format?topic-reply-list...) but this won't work for databases that cannot override those separators.
Does this feature exist natively in Vertica?
If not then does anyone have any experience doing so with external tools?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.