Re: Getting specific partition from the partition name

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, Aug 8, 2024 at 4:46 PM Greg Sabino Mullane <htamfids@xxxxxxxxx> wrote:

YYYY_MM_DD is already setup for sorting, so just do:

SELECT table_name FROM information_schema.tables WHERE table_name ~ 'table_part_p' ORDER BY 1 DESC;

If you need to grab the numbers:

SELECT substring('table_part_p2022_03_04' from '([\d_]+)$');

What if the partitions aren't all rationally named?  There must be a pg_* table out there which contains the partition boundaries...

--

Death to America, and butter sauce.

Iraq lobster!