Get tables ending with numbers

[Sathesh S <sathesh.sundaram@xxxxxxxxxxx>]

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]'

Can someone please give some idea on this.

Thanks,
Sathesh