Re: Views, indices and pg_dump

"Richard Huxton" <dev@archonet.com> writes:
>> Another, slightly unrelated question: Why does pg_dump dump the view as a
>> normal table?

> Mine dumps as a CREATE VIEW statement - can you provide an example (with
> which version of PG you are using).

IIRC, all pre-7.1 releases will dump views as CREATE TABLE + CREATE
RULE.  Which works, but exposes the underlying implementation more than
it should.

            regards, tom lane