根据视图名称查询PostgreSQL数据库的视图信息的sql语句
时间: 2024-01-13 15:04:17 浏览: 82
查询数据库中有数据的表SQL语句
5星 · 资源好评率100%
SELECT table_name AS view_name, table_type AS view_type, is_updatable AS updatable
FROM information_schema.tables
WHERE table_schema='public' AND table_type='VIEW' AND table_name='视图名称';
阅读全文