Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni(dot)ruuhimaki(at)kymi(dot)com> writes:
> Just noticed that 7.4.1 template1 has 40 views / tables in it and copies all
> of them to new databases.
It's supposed to.
> Tried to DROP them in template1 and in a dummy db
> but got an error e.g. 'table "sql_features" does not exist'
information_schema isn't in your search path by default.
I think most of your confusion stems from using an ancient psql ---
since it's not showing a version number in the welcome banner,
it must be older than 7.3, which means it does not know about schemas.
regards, tom lane