MIME-Version: 1.0
References: <CAB+=1TUgzD7CfGbgiBAgcuttN06X11787WvJSeCPs=ek5qCgxw@mail.gmail.com>
 <CAKAnmmLRnzV2C6XBzu64Let3jtABh1P2sGbHBcfAfKpT22ufVQ@mail.gmail.com>
In-Reply-To: <CAKAnmmLRnzV2C6XBzu64Let3jtABh1P2sGbHBcfAfKpT22ufVQ@mail.gmail.com>
From: veem v <veema0000@gmail.com>
Date: Fri, 9 Aug 2024 16:53:09 +0530
Message-ID: <CAB+=1TWjmD+af_+5MmBL1=VZE3Sw0KHD1kGbtZMNhtzfBe-T+Q@mail.gmail.com>
Subject: Re: Getting specific partition from the partition name
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e22ae9061f3e5ec2"
Archived-At: <https://www.postgresql.org/message-id/CAB%2B%3D1TWjmD%2Baf_%2B5MmBL1%3DVZE3Sw0KHD1kGbtZMNhtzfBe-T%2BQ%40mail.gmail.com>
Precedence: bulk

--000000000000e22ae9061f3e5ec2
Content-Type: text/plain; charset="UTF-8"

This helps. Thank you very much.

On Fri, 9 Aug 2024 at 02:15, Greg Sabino Mullane <htamfids@gmail.com> 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_]+)$');
>
> Cheers,
> Greg
>
>

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

<div dir=3D"ltr">This helps. Thank you very much.</div><br><div class=3D"gm=
ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 9 Aug 2024 at 02:1=
5, Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@g=
mail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-le=
ft:1ex"><div dir=3D"ltr">YYYY_MM_DD is already setup for sorting, so just d=
o:<div><br></div><div>SELECT table_name FROM information_schema.tables WHER=
E 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 s=
ubstring(&#39;table_part_p2022_03_04&#39; from &#39;([\d_]+)$&#39;);<br></d=
iv><div><br></div><div>Cheers,<br></div><div>Greg</div><div><br></div></div=
>
</blockquote></div>

--000000000000e22ae9061f3e5ec2--