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

Re: rename of a view

From: Neil Conway <neilc(at)samurai(dot)com>
To: Susanne Ebrecht <miracee(at)miracee(dot)de>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: rename of a view
Date: 2007-06-28 15:27:13
Message-ID: 1183044433.6694.0.camel@goldbach (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
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



In response to

Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2007-06-29 01:06:20
Subject: Re: proposed FAQ entry
Previous:From: Tom LaneDate: 2007-06-28 14:16:51
Subject: Re: rename of a view

pgsql-patches by date

Next:From: Patrick WelcheDate: 2007-06-28 18:24:30
Subject: configure.in / xml / quoting trouble
Previous:From: Tom LaneDate: 2007-06-28 14:25:54
Subject: Re: Doc update for pg_start_backup

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