Re: Rename of a Table Column - Mailing list pgsql-admin

From Brett W. McCoy
Subject Re: Rename of a Table Column
Date
Msg-id Pine.LNX.4.30.0110191719130.21563-100000@chapelperilous.net
Whole thread Raw
In response to Rename of a Table Column  ("James Kelty" <jamesk@ashlandagency.com>)
List pgsql-admin
On Fri, 19 Oct 2001, James Kelty wrote:

> I have a table with a column that needs renameing. I do not know how to do
> this, and if anyone could point me in the right direction, I would really
> appreciate it!

ALTER TABLE <table> RENAME <oldname> TO <newname>;

This is documented in the PostgreSQL reference manual:

http://postgresql.cokernet.com/users-lounge/docs/7.1/reference/

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Chicken Little only has to be right once.


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Rename of a Table Column
Next
From: Brett Schwarz
Date:
Subject: Re: Please help - tks