This problem of how to import data from a PG backup.sql file, is proving quite challenging, because the export has bytea columns, and parsing which value-index from the insert stmt needing conversion to suite H2 is non-trivial; does anyone have suggestion on how to do handle bytea data from pg dumps?
I've already solved most of the other PG dialect issues (casts as ::, convert with/out timezone to implicit/none, etc), but tracking the values and aligning to the DDL-type and ordinal position is another thing :-) Maybe, H2 when in the PG-behavior mode, could just treat BYTEA data like PG does...(?) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
