On Jun 28, 4:10 am, Mateusz <[email protected]> wrote:
> is there any way in H2 database to move existing tables to different > schema. I am new to H2 and am not where I can try it, but did you try something like this? CREATE TABLE my_schema.table_a AS SELECT * FROM public.table_a; And then drop the old one in public? -- 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.
