Re: Get tables ending with numbers

[Sathesh S <Sathesh.Sundaram@xxxxxxxxxxx>]

Thanks Tom & Charles.

 

-Sathesh

 

From: Charles Clavadetscher
Sent: Wednesday, February 15, 2017 12:05 PM
To: 'Sathesh S'; 'pgsql-general'
Subject: RE: Get tables ending with numbers

 

Hello Sathesh

> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Sathesh S
> Sent: Mittwoch, 15. Februar 2017 07:17
> To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
> Subject: Get tables ending with numbers
>
> Hi All,
>
> 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 '%[0-9]'

You should use an operator for regexp:

CREATE TABLE test_20160215 (id integer);
CREATE TABLE

SELECT relname FROM pg_class WHERE relname ~ '[0-9]';
    relname
---------------
[snip]
 test_20160215
[snip]

Or

SELECT relname FROM pg_class WHERE relname ~ 'test_[0-9]+$';
    relname
---------------
 test_20160215
(1 row)

Regards
Charles

> Can someone please give some idea on this.
>
> Thanks,
> Sathesh
>