Skip site navigation (1) Skip section navigation (2)

Re: pg_dump dumps views as tables???

From: "Gerard Mason" <gerardmason(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump dumps views as tables???
Date: 2001-06-19 08:12:32
Message-ID: 9gn1a0$2det$1@news.tht.net (view raw or flat)
Thread:
Lists: pgsql-admin
Anybody?


"Gerard Mason" <gerardmason(at)hotmail(dot)com> wrote in message
news:9gbd3s$2d6$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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.
>
>
>



In response to

Responses

pgsql-admin by date

Next:From: Luis SousaDate: 2001-06-19 16:02:40
Subject: Re: Rule ON DELETE, to perform to DELETE querys !
Previous:From: Jie LiangDate: 2001-06-18 22:39:31
Subject: what's this mean??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group