Start a new topic

Support CSV (comma-separated value) format

DB Visualizer supports character separated value format. It should support comma-separated value export format with a single selection and not require the specification of multiple settings or changing the SQL to get it right.


CSV is a very common format:

https://en.wikipedia.org/wiki/Comma-separated_values


It's simple to implement and should be implemented. Ideally, it should give the option of quoting all fields always or only when required by the specification (i.e. when the separator or single quote or double quotes are contained in the field value).


Additionally, if the CSV implementation could specify separator character then correct TSV (tab separated values) and PSV (pipe separated value) files could also be easily generated.


Sorry: this is my mistake. I'm new to DB Visualizer and my teammate who got me to start using it told me that the CSV files were not properly formatted. It's true that the default separator for CSV files oddly appears to be a tab but that's not a big deal: after testing it out the quoting and escaping are correct.

Kevin,


The current CSV functionality supports both the character and comma separated formats.


Would be great if you can tell what you believe is missing.


Regards


Roger

Login or Signup to post a comment