How to rename a document field in a MongoDB?

Question

How is possible to rename a field in multiples documents in a MongoDB? I have a collections with elements like this, and I want the rename the field "name" by "userName" in all the collection

{
    "name"       : "luisPerez",
    "address"    : "Gaiman",
    "addressFmt" : "Gaiman, Chubut Province, Argentina",
    "loc" : {
        "type" : "Point",
        "coordinates" : [ -65.4920111, -43.2895976  ]
    }, 
}

score 26 · Accepted Answer · answered Mar 11 '17 at 14:17

26

You may use rename operator to rename your fields

db.coll.update({}, {$rename:{"name":"userName"}}, false, true);

false : upsert:false
true : multi:true

answered Mar 11 '17 at 14:17

Rahul

15,979
4
42
63

In pymongo, this looks like `db.coll.update_many({}, {"$rename": {"name": "userName"}})`, since `update` is deprecated. – Noumenon Sep 03 '21 at 18:17

score 5 · Answer 2 · edited May 23 '17 at 12:25

5

Posible duplicity with:

How can I rename a field for all documents in MongoDB?

Posible use $rename

db.collection({}, {$rename:{"name":"userName"}}, false, true);

edited May 23 '17 at 12:25

Community

1
1

answered Mar 11 '17 at 14:17

Matej Marconak

1,365
3
20
25

score 0 · Answer 3 · answered Mar 11 '17 at 14:19

0

You can check this link: https://docs.mongodb.com/manual/reference/operator/update/rename/

It is a new feature of 3.2 - 3.4 . If you have previous version, you have to pass all documents and set new field and after that unset the previous one.

answered Mar 11 '17 at 14:19

Moi Syme

466
2
8

How to rename a document field in a MongoDB?

3 Answers3

Linked