Re: Plans for partitioning of inheriting tables - Mailing list pgsql-general

From thiemo@gelassene-pferde.biz
Subject Re: Plans for partitioning of inheriting tables
Date
Msg-id 20241102001013.Horde.g70bTplHNWnh_M3vk9I-edj@webmail.gelassene-pferde.biz
Whole thread Raw
In response to Re: Plans for partitioning of inheriting tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Plans for partitioning of inheriting tables
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.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.





pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Plans for partitioning of inheriting tables
Next
From: Adrian Klaver
Date:
Subject: Re: Plans for partitioning of inheriting tables