How to Get Partition Table DDL
- 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
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