pg_dump dumps views as tables???

From: "Gerard Mason" <gerardmason(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump dumps views as tables???
Date: 2001-06-14 22:20:18
Message-ID: 9gbd3s$2d6$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andre Schubert 2001-06-15 06:54:19 SRPMS
Previous Message Rebi Varghese 2001-06-14 18:26:25 openBSD