Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> escribió:
> On 11/1/24 13:47, Thiemo Kellner wrote:
>> It looks to me basically to be a "create table A as select * from B
>> where false".
>
> No it more capable then that.
Yes, I wrote basically, not exactly.
> CREATE TABLE <some_tbl> LIKE <some_other_tbl> has like_option which
> allows to transfer over more attributes of the table, for example
> defaults, constraints, indexes, etc.
But, to my understanding, no primary nor unique nor foreign constraint.