From: | "omid omoomi" <oomoomi(at)hotmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Using Tables from another database. |
Date: | 2002-07-25 17:32:45 |
Message-ID: | F260ZichUp9XghaF9c50001623e@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2002-07-25 17:36:32 | Re: Using Tables from another database. |
Previous Message | Yudie@axiontech.com | 2002-07-25 17:20:13 | problem with plpgsql trigger function: parse error near "" |