On Thu, Nov 16, 2006 at 06:23:23PM -0700, Jim Nasby wrote:
> Well, for tables it wouldn't be hard to craft a query that spits out
> the appropriate ALTER TABLE RENAME statements. Unfortunately, ALTER
> TABLE doesn't support renaming columns, but it might be safe to run
> an update on the system tables to accomplish that.
Sorry?
# \h alter table
<snip>
ALTER TABLE [ ONLY ] name [ * ]
RENAME [ COLUMN ] column TO new_column
ALTER TABLE name
RENAME TO new_name
<snip>
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.