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.