Postgres Pro
Downloads
Home   >   mailing lists

Re: Vertical partition - Mailing list pgsql-general

From Rama Krishnan
Subject Re: Vertical partition
Date
Msg-id CAJWX+EPjDCS9tnCjus7o5Gq2=JJ-PXSptSBvze1xcFNL1nfudA@mail.gmail.com
Whole thread Raw
In response to Re: Vertical partition  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Vertical partition
List pgsql-general
Tree view
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.
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Vertical partition
Next
From: "David G. Johnston"
Date:
Subject: Re: Vertical partition