Vertical partition

Started by Rama Krishnanalmost 4 years ago4 messagesgeneral
Jump to latest
#1Rama Krishnan
raghuldrag@gmail.com

Hi ,

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

Thanks
RamaKrishnan

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Rama Krishnan (#1)
Re: Vertical partition

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.

#3Rama Krishnan
raghuldrag@gmail.com
In reply to: David G. Johnston (#2)
Re: Vertical partition

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:

Show quoted text

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.

#4David G. Johnston
david.g.johnston@gmail.com
In reply to: Rama Krishnan (#3)
Re: Vertical partition

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.