Re: Plans for partitioning of inheriting tables

Thiemo Kellner <thiemo@gelassene-pferde.biz>

From: thiemo@gelassene-pferde.biz
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2024-11-01T23:10:13Z
Lists: 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.