Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 014E89FC183
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Thu, 28 Jun 2007 12:27:27 -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 26665-08 for <pgsql-docs-postgresql.org@postgresql.org>;
	Thu, 28 Jun 2007 12:27:22 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82])
	by postgresql.org (Postfix) with ESMTP id 295479FB7B3
	for <pgsql-docs@postgresql.org>; Thu, 28 Jun 2007 12:27:22 -0300 (ADT)
Received: from localhost (mailbox.samurai.com [205.207.28.82])
	by mailbox.samurai.com (Postfix) with ESMTP id 8BE0A61D00;
	Thu, 28 Jun 2007 11:27:21 -0400 (EDT)
X-Virus-Scanned: by amavisd-new at mailbox.samurai.com
Received: from mailbox.samurai.com ([205.207.28.82])
	by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new,
	port 10024)
	with LMTP id 1ObB8otVnMI4; Thu, 28 Jun 2007 11:27:18 -0400 (EDT)
Received: from [192.168.1.167] (adsl-76-225-157-29.dsl.pltn13.sbcglobal.net
	[76.225.157.29]) (using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by mailbox.samurai.com (Postfix) with ESMTP id 7A13C61CD6;
	Thu, 28 Jun 2007 11:27:17 -0400 (EDT)
Subject: Re: rename of a view
From: Neil Conway <neilc@samurai.com>
To: Susanne Ebrecht <miracee@miracee.de>
Cc: pgsql-docs@postgresql.org
In-Reply-To: <46839C05.7050307@miracee.de>
References: <46839C05.7050307@miracee.de>
Content-Type: text/plain
Date: Thu, 28 Jun 2007 08:27:13 -0700
Message-Id: <1183044433.6694.0.camel@goldbach>
Mime-Version: 1.0
X-Mailer: Evolution 2.10.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/24
X-Sequence-Number: 4313

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