I believe this should work.
dslContext.createTable("woot")
.as(
dslContext.select(field("somefield"))
.from(table("some_other_table"))
.where(DSL.trueCondition())
)
.execute();
On Wed, Jul 6, 2016 at 2:02 PM, <[email protected]> wrote:
> Hello,
> i would like to know if there is a way to generate a request like this :
>
> CREATE TABLE NEW_TABLE_NAME AS
> SELECT [ column1, column2...columnN ]
> FROM EXISTING_TABLE_NAME
> [ WHERE ]
>
>
> If not what is the most effcient way to copy rows from a table to a new
> one ?
> Thanks
>
> --
> 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 [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Thank you
Samir Faci
https://keybase.io/csgeek
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
