rename of a view

From: Susanne Ebrecht <miracee(at)miracee(dot)de>
To: pgsql-docs(at)postgresql(dot)org
Subject: rename of a view
Date: 2007-06-28 11:31:17
Message-ID: 46839C05.7050307@miracee.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2007-06-28 14:16:51 Re: rename of a view
Previous Message Josh Berkus 2007-06-27 23:19:45 Re: Volunteer to build a configuration tool

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-06-28 12:01:56 Doc update for pg_start_backup
Previous Message Jacob Rief 2007-06-28 10:08:37 Re: SPI-header-files safe for C++-compiler