export h2 to CSV

[Giovanni Martinez]

I have an H2 database that I need to access. My goal is,first,  from the command line, going into the database and check what I have. Second, export all the data to CSV. How can I do that?

[Giovanni Martinez]

I connected to the database using PyCharm Pro. I connected to the database using the following connection string: jdbc:h2:file:/var/lib/rundeck/data/rundeckdb.mv.db. But I still don't see my schema.

[Evgenij Ryazanov]

Hello.

You can use CSVWRITE function to export some table or query results to CSV:

http://h2database.com/html/functions.html#csvwrite

There in so way to export the whole database to CSV, because database may contain multiple tables and other objects.

But you can use SCRIPT TO command to export everything to SQL if you need it:

http://h2database.com/html/grammar.html#script

[Giovanni Martinez]

thank you