[h2] Re: Help needed for COLUMN option in SCRIPT

[Sudeep C]

Is there any other option to retrieve the INSERT statement with column 
names using the above tool?

On Monday, September 26, 2022 at 9:05:29 PM UTC+5:30 Evgenij Ryazanov wrote:

> Hello!
>
> Unfortunately, this tool doesn't support all clauses of the SCRIPT 
> command. You need to use the Shell tool or H2 Console or JDBC connection to 
> the database.
>
> Valid SQL command will be SCRIPT COLUMNS TO 'backup.sql'
>
> https://h2database.com/html/commands.html#script
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/646c9ee0-2918-438a-8b6c-40888438a9ben%40googlegroups.com.

[h2] Re: Help needed for COLUMN option in SCRIPT

[Evgenij Ryazanov]

Hello!

Unfortunately, this tool doesn't support all clauses of the SCRIPT command. 
You need to use the Shell tool or H2 Console or JDBC connection to the 
database.

Valid SQL command will be SCRIPT COLUMNS TO 'backup.sql'

https://h2database.com/html/commands.html#script

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/153851f8-2f95-40f6-af28-ad792ab9179fn%40googlegroups.com.