Skip site navigation (1) Skip section navigation (2)

Re: rename of a view

From: Susanne Ebrecht <miracee(at)miracee(dot)de>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: rename of a view
Date: 2007-06-29 18:32:44
Message-ID: 4685504C.1000007@miracee.de (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
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


In response to

pgsql-docs by date

Next:From: David FetterDate: 2007-06-30 00:16:53
Subject: Re: rename of a view
Previous:From: David FetterDate: 2007-06-29 18:32:19
Subject: Re: rename of a view

pgsql-patches by date

Next:From: Neil ConwayDate: 2007-06-29 19:43:00
Subject: Re: SPI-header-files safe for C++-compiler
Previous:From: David FetterDate: 2007-06-29 18:32:19
Subject: Re: rename of a view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group