pg_dump dumps views as tables???

Поиск
Список
Период
Сортировка
Искать
От
Gerard Mason
Тема
pg_dump dumps views as tables???
Дата
Msg-id
9gbd3s$2d6$1@news.tht.net
Список
Дерево обсуждения
Re: pg_dump dumps views as tables??? "Gerard Mason" <gerardmason@hotmail.com>
Re: Re: pg_dump dumps views as tables??? "Ross J. Reedstrom" <reedstrm@rice.edu>
Re: Re: pg_dump dumps views as tables??? Stephan Szabo <sszabo@megazone23.bigpanda.com>
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.



В списке pgsql-admin по дате отправления
От: Richard Huxton
Дата:
Сообщение: Re: [SQL] log file
От: David M. Richter
Дата:
Сообщение: IRIX AND POSTGRES 7.1.2
FAQ