Skip to content

Instantly share code, notes, and snippets.

@danilkuznetsov

danilkuznetsov/Export data from H2 database into CSV

Last active June 14, 2023 00:23
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danilkuznetsov/c37f1737abdca78e6a0e2688d9f50173 to your computer and use it in GitHub Desktop.
Save danilkuznetsov/c37f1737abdca78e6a0e2688d9f50173 to your computer and use it in GitHub Desktop.
Download ZIP
Export data from H2 database into CSV
Raw
Export data from H2 database into CSV
CALL CSVWRITE('/home/<user>/downloads/<table_name>'.csv', 'SELECT * FROM <table_name>', 'charset=UTF-8 fieldSeparator=;');
Without field delimiter "
CALL CSVWRITE('/home/<user>/downloads/<table_name>'.csv', 'SELECT * FROM <table_name>', 'charset=UTF-8 fieldSeparator=; fieldDelimiter=');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment