Using Tables from another database.

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