Django queries - id vs pk

django orm primary-key
Art picture Art · Jan 30, 2010 · Viewed 53.7k times · Source

When writing django queries one can use both id/pk as query parameters.

Object.objects.get(id=1)
Object.objects.get(pk=1)

I know that pk stands for Primary Key and is just a shortcut, according to django's documentation. However it is not clear when one should be using id or pk.

Answer

Felix Kling picture Felix Kling · Jan 30, 2010

It doesn't matter. pk is more independent from the actual primary key field i.e. you don't need to care whether the primary key field is called id or object_id or whatever.

It also provides more consistency if you have models with different primary key fields.

Related questions

select and update database record with a single queryset

How do I run an update and select statements on the same queryset rather than having to do two queries: - one to select the object - and one to update the object The equivalent in SQL would be something …

Read More
Why does django's prefetch_related() only work with all() and not filter()?

suppose I have this model: class PhotoAlbum(models.Model): title = models.CharField(max_length=128) author = models.CharField(max_length=128) class Photo(models.Model): album = models.ForeignKey('PhotoAlbum') format = models.IntegerField() Now if I want to look at a subset of …

Read More
How to store a dictionary on a Django Model?

I need to store some data in a Django model. These data are not equal to all instances of the model. At first I thought about subclassing the model, but I’m trying to keep the application flexible. If I …

Read More