HI Dear PostgreSQL team,
I have created a partition table as bellow:
*CREATE TABLE* measurement_year_month (
logdate date not null,
peaktemp int,
unitsales int
) PARTITION BY RANGE (EXTRACT(YEAR FROM logdate), EXTRACT(MONTH FROM
logdate));
so the content for this column *partexprs* for
HI Dear PostgreSQL,
I am pretty new for this DB.
I have created two partition tables as bellow:
*CREATE TABLE* measurement_year_month (
logdate date not null,
peaktemp int,
unitsales int
) PARTITION BY RANGE (EXTRACT(YEAR FROM logdate), EXTRACT(MONTH FROM
logdate));
*create table* partition
HI,
I have created some partition table, as example bellow:
CREATE TABLE public.measurement
(
city_id integer NOT NULL,
logdate date NOT NULL,
peaktemp integer,
unitsales integer
) PARTITION BY RANGE (logdate) ;
CREATE TABLE public.measurement_y2006m02 PARTITION OF public.measu
