Re: rename of a view - Mailing list pgsql-docs

From Neil Conway
Subject Re: rename of a view
Date
Msg-id 1183044433.6694.0.camel@goldbach
Whole thread Raw
In response to rename of a view  (Susanne Ebrecht <miracee@miracee.de>)
Responses Re: rename of a view
List pgsql-docs
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...

-Neil



pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: rename of a view
Next
From: Bruce Momjian
Date:
Subject: Re: proposed FAQ entry