Demo entry 3835143

test001

   

Submitted by anonymous on Mar 02, 2016 at 05:18
Language: PostgreSQL SQL dialect. Code size: 363 Bytes.

select
    ns.nspname || '.' || cl.relname as table_name
from pg_namespace as ns
join pg_class as cl
    on cl.relnamespace = ns.oid
where ns.nspname in (
    'config', 'statistics', 'twc',
    'log', 'policy', 'system'
)
    and (cl.relkind = 'v' or cl.relkind = 'r')
    and cl.relname !~ '_[0-9]{4}_[0-9]{2}$'
order by ns.nspname asc, cl.relname asc

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).