Can a query involve tables from different schemas?
Massimo
On Wednesday, 4 April 2012 16:46:30 UTC-5, Wuwei wrote:
>
> Massimo,
> I think it is very simple to support schemas: you should simply allow a .
> (dot) in table name.
> So that we can define a table like this:
> db.define_table('myschema.mytable', Field(....), ...)
>
> This syntax now raises an exception:
> SyntaxError: only [0-9a-zA-Z_] allowed in table and field names, receiving
> myschema.mytable
>
> In this way generated sql query will be like:
> select * from myschema.mytable
>
> which is exactly what I need.
> I think that also joins between tables from different schemas will work
> well.
>
> Thank you.
>
> Il giorno sabato 24 marzo 2012 00:51:56 UTC+1, Massimo Di Pierro ha
> scritto:
>>
>> I am not sure if this can be done or not. If not supported, we can add
>> support. Can you open a ticket and post an example of how to do it in SQL?
>>
>>
>>
