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