avamingli commented on issue #1556:
URL: https://github.com/apache/cloudberry/issues/1556#issuecomment-3985212591
```sql
CREATE TABLE table1_2024 PARTITION OF table1
FOR VALUES FROM ('2024-01-01') TO ('2025-01-01');
```
create a child to verify.
```shell
pg_dump -t table1 -t 'table1_*' --schema-only
pg_dump: warning: unsupport am pax yet, current relation "t1" will be ignore
--
-- Name: table1; Type: TABLE; Schema: public; Owner: gpadmin
--
CREATE TABLE public.table1 (
combinedbtn character varying(200) NOT NULL,
startdate date NOT NULL
)
PARTITION BY RANGE (startdate) DISTRIBUTED BY (combinedbtn);
ALTER TABLE public.table1 OWNER TO gpadmin;
SET default_table_access_method = heap;
--
-- Name: table1_2024; Type: TABLE; Schema: public; Owner: gpadmin
--
CREATE TABLE public.table1_2024 (
combinedbtn character varying(200) NOT NULL,
startdate date NOT NULL
) DISTRIBUTED BY (combinedbtn);
ALTER TABLE public.table1_2024 OWNER TO gpadmin;
--
-- Name: table1_2024; Type: TABLE ATTACH; Schema: public; Owner: gpadmin
--
ALTER TABLE ONLY public.table1 ATTACH PARTITION public.table1_2024 FOR
VALUES FROM ('2024-01-01') TO ('2025-01-01');
--
-- Apache Cloudberry database dump complete
--
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
