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