From: | Sathesh S <Sathesh(dot)Sundaram(at)hotmail(dot)com> |
---|---|
To: | Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>, 'pgsql-general' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Get tables ending with numbers |
Date: | 2017-02-15 17:15:36 |
Message-ID: | AM5PR10MB0689C7153239DB16D065288B825B0@AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Tom & Charles.
-Sathesh
From: Charles Clavadetscher<mailto:clavadetscher(at)swisspug(dot)org>
Sent: Wednesday, February 15, 2017 12:05 PM
To: 'Sathesh S'<mailto:sathesh(dot)sundaram(at)hotmail(dot)com>; 'pgsql-general'<mailto:pgsql-general(at)postgresql(dot)org>
Subject: RE: [GENERAL] Get tables ending with numbers
Hello Sathesh
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Sathesh S
> Sent: Mittwoch, 15. Februar 2017 07:17
> To: pgsql-general <pgsql-general(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-02-15 17:17:27 | Re: Can't restart Postgres |
Previous Message | Adrian Klaver | 2017-02-15 17:15:10 | Re: Can't restart Postgres |