Hello Sathesh > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Sathesh S > Sent: Mittwoch, 15. Februar 2017 07:17 > To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx> > Subject: 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
