Re: Using Tables from another database.

hi,
You may simply write:

create view  view_test as select * from mytable;

But if the your table is in another database, then I am sorry. no way.

regards
Omid Omoomi


>From: Rog�rio Baldini das Neves <baldini@infoquest.com.br>
>To: <pgsql-sql@postgresql.org>
>Subject: [SQL] Using Tables from another database.
>Date: Thu, 25 Jul 2002 10:36:09 -0300
>
>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
>
>




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com