Thread: Vertical partition

Vertical partition

From
Rama Krishnan
Date:
Hi , 

Can you pls tell us how to do a vertical partition in postgresql


Thanks
RamaKrishnan

Re: Vertical partition

From
"David G. Johnston"
Date:


On Friday, May 6, 2022, Rama Krishnan <raghuldrag@gmail.com> wrote:
Hi , 

Can you pls tell us how to do a vertical partition in postgresql


Manually.  “Create table” with the columns you want in each.  You FK column will also be your PK column on the non-primary table.

David J.
 

Re: Vertical partition

From
Rama Krishnan
Date:
Thanks a lot.  Which means normal primary key and foreign key relationship right can u pls send me any reference link

On Sat, 7 May, 2022, 06:21 David G. Johnston, <david.g.johnston@gmail.com> wrote:


On Friday, May 6, 2022, Rama Krishnan <raghuldrag@gmail.com> wrote:
Hi , 

Can you pls tell us how to do a vertical partition in postgresql


Manually.  “Create table” with the columns you want in each.  You FK column will also be your PK column on the non-primary table.

David J.
 

Re: Vertical partition

From
"David G. Johnston"
Date:
On Friday, May 6, 2022, Rama Krishnan <raghuldrag@gmail.com> wrote:
Thanks a lot.  Which means normal primary key and foreign key relationship right can u pls send me any reference link

Like what?  Read the documentation for those commands and features.

David J.