PostgreSQL and Django Query

Question

I'm trying to make a (Django) query to my database using the following syntax:

Derp.objects.all()

I have a production database and a default (development) database. So obviously, by default, that query above will use the default database.

I'm having trouble figuring out how to select my other database. A coworker suggested the following:

Derp.objects.all(using="development")

But that returns a TypeError:

all() got an unexpected keyword argument 'using'

Can someone tell me what the proper syntax is? I can't seem to find what parameters the all() method will actually accept.

Answer 1

Your syntax is slightly off:

Derp.objects.using('production').all()

Obviously, the 'production' key needs to match whatever you've labeled your DB in settings.py.