How to add partitions to the existing table in PostgreSQL - Mailing list pgsql-admin

From Naveen Kumar
Subject How to add partitions to the existing table in PostgreSQL
Date
Msg-id CAN+uLsHX4mQq3m5Ev8szQQwU4gxijMMoO8XDAubm0GdmEKEdsg@mail.gmail.com
Whole thread Raw
Responses Re: How to add partitions to the existing table in PostgreSQL
Re: How to add partitions to the existing table in PostgreSQL
List pgsql-admin
How to add partitions to the existing table in PostgreSQL

for ex, below is my table definition:

CREATE TABLE ot.employee
(
    empno smallint NOT NULL,
    ename character varying(20),
    job character varying(20),
    deptno smallint
)

Now I would like to add partition to deptno column

I don't see any alter table command to add the partition to the existing table.

Please help me on this.

Thank you
Naveen

pgsql-admin by date:

Previous
From: Naveen Kumar
Date:
Subject: Re: How to return multiple rows by stored procedure in postgresql
Next
From: Paul Förster
Date:
Subject: Re: How to return multiple rows by stored procedure in postgresql