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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
