Re: [GENERAL] Get tables ending with numbers

2017-02-15 Thread Sathesh S
ject: 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 > Subject:

Re: [GENERAL] Get tables ending with numbers

2017-02-14 Thread Charles Clavadetscher
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 > Subject: [GENERAL] Get tables ending with numbers > >

Re: [GENERAL] Get tables ending with numbers

2017-02-14 Thread Tom Lane
Sathesh S writes: > 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 '%

[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