MIME-Version: 1.0
References: <CAB+=1TUgzD7CfGbgiBAgcuttN06X11787WvJSeCPs=ek5qCgxw@mail.gmail.com>
In-Reply-To: <CAB+=1TUgzD7CfGbgiBAgcuttN06X11787WvJSeCPs=ek5qCgxw@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Thu, 8 Aug 2024 16:45:18 -0400
Message-ID: <CAKAnmmLRnzV2C6XBzu64Let3jtABh1P2sGbHBcfAfKpT22ufVQ@mail.gmail.com>
Subject: Re: Getting specific partition from the partition name
To: veem v <veema0000@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000610ea061f321dc0"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLRnzV2C6XBzu64Let3jtABh1P2sGbHBcfAfKpT22ufVQ%40mail.gmail.com>
Precedence: bulk

--0000000000000610ea061f321dc0
Content-Type: text/plain; charset="UTF-8"

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_]+)$');

Cheers,
Greg

--0000000000000610ea061f321dc0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">YYYY_MM_DD is already setup for sorting, so just do:<div><=
br></div><div>SELECT table_name FROM information_schema.tables WHERE table_=
name ~ &#39;table_part_p&#39; ORDER BY 1 DESC;<br></div><div><br></div><div=
>If you need to grab the numbers:</div><div><br></div><div>SELECT substring=
(&#39;table_part_p2022_03_04&#39; from &#39;([\d_]+)$&#39;);<br></div><div>=
<br></div><div>Cheers,<br></div><div>Greg</div><div><br></div></div>

--0000000000000610ea061f321dc0--