Re: Views, indices and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "Zak McGregor" <zak(at)mighty(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org
Subject: Re: Views, indices and pg_dump
Date: 2001-03-27 15:13:38
Message-ID: 5234.985706018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Richard Huxton" <dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-03-27 15:19:32 Re: help request
Previous Message antken 2001-03-27 15:05:55 Starting postgresql on startup