Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Get tables ending with numbers - Mailing list pgsql-general

From Sathesh S
Subject [GENERAL] Get tables ending with numbers
Date
Msg-id AM5PR10MB06895D3FC5E6F9EBF3C737AD825B0@AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: [GENERAL] Get tables ending with numbers  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] Get tables ending with numbers  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
List pgsql-general
Tree view

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 please give some idea on this.

Thanks,
Sathesh

pgsql-general by date:

Previous
From: Gmail
Date:
Subject: Re: [GENERAL] Can't restart Postgres
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: [GENERAL] Get tables ending with numbers