Hacker News Reader

Comment by integraton | Hacker News Reader

Agreed.

PostgreSQL:

    ALTER TABLE posts RENAME COLUMN author TO writer;

MongoDB:

    db.posts.update({}, {$rename:{"author":"writer"}}, false, true);

(I'm excluding RethinkDB since it's still under development and doesn't have a rename command yet)

I don't think it really needs a `rename` command. The query language supports it without:

    r.table('posts').replace(function(item) { return item.without('author').merge({writer: item('name')}); })

That works, but it is a bit annoying to type. We'll add a porcelain command for this soon. See https://github.com/rethinkdb/rethinkdb/issues/881.