Thanks Tom & Charles.
-Sathesh
From: Charles Clavadetscher<mailto:clavadetsc...@swisspug.org>
Sent: Wednesday, February 15, 2017 12:05 PM
To: 'Sathesh S'<mailto:sathesh.sunda...@hotmail.com>;
'pgsql-general'<mailto:pgsql-general@postgresql.org>
Sub
Hello Sathesh
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sathesh S
> Sent: Mittwoch, 15. Februar 2017 07:17
> To: pgsql-general
> Subject: [GENERAL] Get tables ending with numbers
>
> Hi All,
>
> Im trying
Sathesh S writes:
> Im trying to get tables ending with numbers (last 8 characters should be
> numbers).
> For example: I have the tables "test_20160215" and "test_20160131" and
> "test_1". When i run the below sql im not getting any output.
> Select relname from pg_class where relname like '%
