Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 345219FB6F8 for ; Thu, 28 Jun 2007 08:31:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 53081-10 for ; Thu, 28 Jun 2007 08:31:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id ED8F69FB6EB for ; Thu, 28 Jun 2007 08:31:28 -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 01F0D5AF028 for ; Thu, 28 Jun 2007 11:31:22 +0000 (GMT) Received: from localhost (mail.nxdomain.de [212.62.87.62]) by mail.nxdomain.de (Postfix) with ESMTP id 1895922A547 for ; Thu, 28 Jun 2007 13:31:14 +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 13935-17 for ; Thu, 28 Jun 2007 13:31:06 +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 4318822A524 for ; Thu, 28 Jun 2007 13:31:06 +0200 (CEST) Message-ID: <46839C05.7050307@miracee.de> Date: Thu, 28 Jun 2007 13:31:17 +0200 From: Susanne Ebrecht User-Agent: Thunderbird 2.0.0.0 (X11/20070426) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: rename of a view 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/22 X-Sequence-Number: 4311 Hi all, I got the question: how can I rename a view? At the first moment, I have had no idea ... and I asked the German guys at IRC. They have had no idea too. 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. Is it possible to add a hint for this to the documentation? Regards, Susanne -- Susanne Ebrecht, 52066 Aachen, Germany