Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 692309FB64D for ; Fri, 29 Jun 2007 15:33:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 58214-08-2 for ; Fri, 29 Jun 2007 15:32:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id CF3169FB4EE for ; Fri, 29 Jun 2007 15:33:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.nxdomain.de (mail.nxdomain.de [212.62.87.62]) by svr4.postgresql.org (Postfix) with ESMTP id E88245AF883 for ; Fri, 29 Jun 2007 18:32:56 +0000 (GMT) Received: from localhost (mail.nxdomain.de [212.62.87.62]) by mail.nxdomain.de (Postfix) with ESMTP id 3324922A5CA; Fri, 29 Jun 2007 20:32:50 +0200 (CEST) Received: from mail.nxdomain.de ([212.62.87.62]) by localhost (mail.nxdomain.de [212.62.87.62]) (amavisd-new, port 10024) with ESMTP id 66179-04; Fri, 29 Jun 2007 20:32:42 +0200 (CEST) Received: from [192.168.44.11] (port-83-236-52-175.dynamic.qsc.de [83.236.52.175]) by mail.nxdomain.de (Postfix) with ESMTP id 4BA7222A5C8; Fri, 29 Jun 2007 20:32:42 +0200 (CEST) Message-ID: <4685504C.1000007@miracee.de> Date: Fri, 29 Jun 2007 20:32:44 +0200 From: Susanne Ebrecht User-Agent: Thunderbird 2.0.0.0 (X11/20070426) MIME-Version: 1.0 To: Neil Conway Cc: pgsql-docs@postgresql.org Subject: Re: rename of a view References: <46839C05.7050307@miracee.de> <1183044433.6694.0.camel@goldbach> In-Reply-To: <1183044433.6694.0.camel@goldbach> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at nxdomain.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/30 X-Sequence-Number: 4319 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