1psql -c "select table_name from INFORMATION_SCHEMA.views WHERE table_schema = ANY (current_schemas(false));" To filter, just use grep. See https://dba.stackexchange.com/questions/23836/how-to-list-all-views-in-sql-in-postgresql