Re: [SQL] Using Tables from another database.

2002-07-26 Thread D'Arcy J.M. Cain
* Reinoud van Leeuwen <[EMAIL PROTECTED]> [020726 08:05]: > On Thu, 25 Jul 2002 17:02:44 + (UTC), [EMAIL PROTECTED] > (Rogério Baldini das Neves) wrote: > >create view view_test as select * from mydb.mytable; > > This is possible in Sybase or Microsoft SQL server, not in Postgresql > (AFAIK)

[SQL] Using Tables from another database.

2002-07-25 Thread 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