Re: rename of a view

[Susanne Ebrecht <miracee(at)miracee(dot)de>]

Neil Conway wrote:
> On Thu, 2007-28-06 at 13:31 +0200, Susanne Ebrecht wrote:
>   
> > Than I just tried: alter table pgview rename to  bettername;
> >
> > that works, but there is no hint at the documentation, that you can 
> > rename a view via alter table.
> >     
>
> >From the ALTER TABLE reference page: "The RENAME forms change the name
> of a table (or an index, sequence, or view) or the name of an individual
> column in a table."
>
> Of course, it could be made more obvious...
>   

I looked at \h ALTER TABLE
my system is in German, and there is no hint, that this is for views too.
Using 8.2.4.

Susanne

--
Susanne Ebrecht,
52066 Aachen, Germany