apache / apache/cloudberry

How to Get Partition Table DDL

Open
#1,556 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

Hi,

I can get the table DDL using below command but unable to see the create partition DDL in it.
Need your support in this regard.

pg_dump -d gpafiniti -t test.table1 --schema-only > 123.sql

OutPut:

CREATE TABLE test.table1 (
combinedbtn character varying(200) NOT NULL,
startdate date NOT NULL,

)
PARTITION BY RANGE (startdate) DISTRIBUTED BY (combinedbtn);

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported pg_dump --schema-only output for the partitioned table described in the issue, then inspect the relevant PostgreSQL or Cloudberry partition-dump documentation and implementation entry points. Done should mean the expected partition-table DDL behavior is documented clearly or the missing behavior is narrowed to a specific, reproducible change.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Documentation
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.