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

Reply via email to