Re: Plans for partitioning of inheriting tables

Поиск
Список
Период
Сортировка
От thiemo@gelassene-pferde.biz
Тема Re: Plans for partitioning of inheriting tables
Дата
Msg-id 20241102001013.Horde.g70bTplHNWnh_M3vk9I-edj@webmail.gelassene-pferde.biz
обсуждение исходный текст
Ответ на Re: Plans for partitioning of inheriting tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Plans for partitioning of inheriting tables
Список 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 по дате отправления: