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