Re: pg_dump dumps views as tables??? - Mailing list pgsql-admin

Anybody?


"Gerard Mason" <gerardmason@hotmail.com> wrote in message
news:9gbd3s$2d6$1@news.tht.net...
> I am running postgresql-server-7.0.3-12mdk (Mandrake 8.0). The relevant
part
> of my build script looks like this:
>
> create view included_works
> as
>   select uuid, title as lhs
>        , trim(to_char(cast(year_of_publication as int), '0000')) as rhs
>     from works
>    where include=true
> ;
>
> What pg_dump actually outputs is this:
>
> CREATE TABLE "included_works" (
>  "uuid" character(36),
>  "lhs" character varying(80),
>  "rhs" text
> );
>
>
> I would be more appalled if I was less gobsmacked. Surely I'm doing
> something wrong? But I can't find any reference to this in either the
Admin
> Guide or the Reference Manual (though admittedly I'm looking at the 7.1
> ones -- the 7.0 ones didn't have any info on it at all, I think).
>
> Help.
>
>
>