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: Rogrio Baldini das Neves <baldini(at)infoquest(dot)com(dot)br>
>To: <pgsql-sql(at)postgresql(dot)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,
>
>Rogrio Baldini
>
>

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