Is there a way to search the earliest or latest postgres partition for table?
First off, many thanks to those who commented and helped me get to this answer. I was not as detailed as I should have been in posting the question. I believe this is the answer I seek:

select table_name from information_schema.tables where table_name like 'table_%' order by table_name limit 1;


It should return the earliest table partition name given the naming conventions we use on them.