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> Subject: RE: [GENERAL] Get tables ending with numbers Hello Sathesh > -----Original Message----- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sathesh S > Sent: Mittwoch, 15. Februar 2017 07:17 > To: pgsql-general <pgsql-general@postgresql.org> > Subject: [GENERAL] Get tables ending with numbers > > 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]' You should use an operator for regexp: CREATE TABLE test_20160215 (id integer); CREATE TABLE SELECT relname FROM pg_class WHERE relname ~ '[0-9]'; relname --------------- [snip] test_20160215 [snip] Or SELECT relname FROM pg_class WHERE relname ~ 'test_[0-9]+$'; relname --------------- test_20160215 (1 row) Regards Charles > Can someone please give some idea on this. > > Thanks, > Sathesh >
