How to retrieve the partition info for each partition table?

Поиск

Список

Период

Сортировка

От	Yuxia Qiu
Тема	How to retrieve the partition info for each partition table?
Дата	24 октября 2018 г. 20:29:21
Msg-id	CAJ0a2RkkmBYEtqek5sKR-f19HS_hKjUf3KLZU7TASiZ9Z-MQLw@mail.gmail.com обсуждение исходный текст
Ответы	RE: How to retrieve the partition info for each partition table? (Igor Neyman <ineyman@perceptron.com>)
Список	pgsql-general

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.measurement

FOR VALUES FROM ('2006-02-01') TO ('2006-03-01');

CREATE TABLE public.measurement_y2006m03 PARTITION OF public.measurement

FOR VALUES FROM ('2006-03-01') TO ('2006-04-01');

I know how to get a list partition tables for above example by calling :

SELECT i.inhrelid::regclass AS child

FROM pg_inherits i

WHERE i.inhparent = 'public.measurement'::regclass;

My question is: how to get the value boundary for each partition table like bellow?

measurement_y2006m02 FROM ('2006-02-01') TO ('2006-03-01')

measurement_y2006m03 FROM ('2006-03-01') TO ('2006-04-01')

Thanks,

Yuxia

В списке pgsql-general по дате отправления:

От: Boris Sagadin
Дата: 24 октября 2018 г., 20:11:59
Сообщение: Re: Postgres 10, slave not catching up with master

От: Igor Neyman
Дата: 24 октября 2018 г., 21:19:25
Сообщение: RE: How to retrieve the partition info for each partition table?