Using a table from database other than 'default'?

[Steve W]

Hi, 

I'm trying to use a table from a database other than 'default.'

I haven't found where to specify that.

Everything else is working except that the lookup is trying to query against the default database and can't find the table:

SQL log:

2013-01-15 08:51:51 PST ERROR:  relation "mytable" does not exist at character 22

If I copy the table into the default database, it does work perfectly, so I assume that the only problem I have is not knowing how to specify the database.

I know of course how to employ the 'using(databasename)' syntax in a regular django view.

I've poked around in the ModelLookup class thinking that may be a good place to look, but I'm not seeing anything that gives me a clue.

Thanks in advance.

[Mark Lavin]

You can extend the ModelLookup.get_queryset to attach the using() clause.

-Mark

[Middle Fork GIS]

Thanks for your quick response.

I'll give it a try and report back if I get something workable.

Steve