Hi everyone,
i have a question, i duplicated a table with:
Table<?> table = DSL.table(DSL.name("dc2", "process"));
dsl.createTable(table).as(dsl.select().from("dc1.process")).withNoData().execute();
but doesn't copy a primary key and foreignkey, how i do?
and if i want to duplicate schema in jooq? thanks Giuseppe
--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/104c349b-4add-472d-97ac-01921da2c131%40googlegroups.com.
Hi Giuseppe,If you're using the code generator to produce your original schema, you can duplicate it relatively easily using:- Runtime schema mapping: https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-database/codegen-database-catalog-and-schema-mapping/- DSLContext.ddl() and/or Meta.ddl()A more convenient syntax will be supported in the future via standard SQL CREATE TABLE (.. LIKE othertable) syntax:Or a synthetic CREATE SCHEMA .. LIKE otherschema syntax:This is a very interesting use-case to pursue in the future of jOOQ, so if you encounter any issues, please do report them.I hope this helps,Lukas
On Wed, Mar 25, 2020 at 1:41 PM <iz8...@gmail.com> wrote:
--Hi everyone,
i have a question, i duplicated a table with:
Table<?> table = DSL.table(DSL.name("dc2", "process")); dsl.createTable(table).as(dsl.select().from("dc1.process")).withNoData().execute();
but doesn't copy a primary key and foreignkey, how i do?
and if i want to duplicate schema in jooq? thanks Giuseppe
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscribe@googlegroups.com.