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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate