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