I just tried it and it works fine. obviously only the data is copied over (no indexes etc).
it was good enough for my purpose though. On Tuesday, June 28, 2011 8:56:49 AM UTC-7, Bryan wrote: > > On Jun 28, 4:10 am, Mateusz <[email protected]> wrote: > > > 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/QpEdpGqVkZgJ. 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.
