[SQL] Using Tables from another database.

[Rogério Baldini das Neves]

Hello,   I need to make a view like:   create view  view_test as select * from mydb.mytable;   and I get this error:   ERROR:  parser: parse error at or near "."   Whats the problem??   How can I solve this problem?   Thanks a lot,   Rogério Baldini