【openGauss或PostgreSQL】查看某个库下模糊批量表或视图名
一、openGauss或PostgreSQL查看某个库下模糊批量表或视图名
select table_catalog
,table_schema
,table_name
,table_type
from information_schema.tables
where table_type in ('BASE TABLE','VIEW')
and table_name ~ 'tzq_log_t'
and table_schema = 'tzq'
and table_catalog = 'tzqdb'
order by table_name;