On Tuesday 10 August 2004 03:14, Olivier Guilyardi wrote:> SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';with 7.4 :
SELECT viewname FROM pg_views WHERE schemaname NOT IN ('pg_catalog','information_schema');
Albert