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.
signature.asc
Description: Digital signature
