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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
