Export data from H2 database into CSV

Question

I have a stand alone H2 server up and running gathering data. For testing I want to get data out my server into a CSV file. Are there any tools for that?

Did you check: h2database.com/html/links.html#tools

user330315
– user330315

2013-06-20 16:29:55 +00:00
Commented Jun 20, 2013 at 16:29 — user330315
– user330315, Commented Jun 20, 2013 at 16:29
H2 has a function to write CSV files. Check CSVWRITE.

jschiavon
– jschiavon

2013-06-21 13:31:33 +00:00
Commented Jun 21, 2013 at 13:31 — jschiavon
– jschiavon, Commented Jun 21, 2013 at 13:31

StackzOfZtuff · Accepted Answer · 2021-05-20 11:47:12Z

89

Try `CSVWRITE`

This is perhaps all that you need:

call CSVWRITE ( 'C:/MyFolder/MyCSV.txt', 'SELECT * FROM MYTABLE' )

You need to just run the call (mentioned above) in the browser based client of H2 that you are most likely using.

Further reading: http://www.h2database.com/html/functions.html#csvwrite.

edited May 20, 2021 at 11:47

StackzOfZtuff

3,2751 gold badge32 silver badges31 bronze badges

answered Oct 29, 2013 at 9:52

partha

2,3265 gold badges28 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MAbraham1 Over a year ago

Probably because the H2 Help command doesn't have any function resembling the term 'export'. I guess you just have to know to look for 'CSV'. See also h2database.com/html/commands.html#script

AnonGeek · Accepted Answer · 2015-05-22 13:54:41Z

10

For small data, you can also use script to export any table:

script table <table_name>

answered May 22, 2015 at 13:54

AnonGeek

8,03811 gold badges42 silver badges56 bronze badges

1 Comment

Zaphod Beeblebrox Over a year ago

Nice answer, but this command produces SQL statements, not a CSV file as requested in the original question.

xplorerdev · Accepted Answer · 2018-09-04 05:02:22Z

4

Another way works for me:

script SIMPLE to 'C:\FolderName\FileName.sql' table SCHEMA.TABLENAME;

answered Sep 4, 2018 at 5:02

xplorerdev

3751 gold badge3 silver badges13 bronze badges

Collectives™ on Stack Overflow

Export data from H2 database into CSV

3 Answers 3

Try `CSVWRITE`

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Try CSVWRITE

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related

Try `CSVWRITE`