Re: [GENERAL] Get tables ending with numbers

2017-02-15 Thread Sathesh S
Thanks Tom & Charles. -Sathesh From: Charles Clavadetscher<mailto:clavadetsc...@swisspug.org> Sent: Wednesday, February 15, 2017 12:05 PM To: 'Sathesh S'<mailto:sathesh.sunda...@hotmail.com>; 'pgsql-general'<mailto:pgsql-general@postgresql.org> Sub

[GENERAL] Get tables ending with numbers

2017-02-14 Thread Sathesh S
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