Postgres -- generate view definition mirroring every table in the public schema

gistfile1.txt

select 'CREATE OR REPLACE VIEW dp_' || table_name ||
  E' AS\nSELECT ' || array_to_string(array_agg(format('%s',column_name)),E',\n       ') ||
  E'\nFROM ' || table_name || E';\n'
from information_schema.columns
where table_schema = 'public'
group by table_name;