From: omid omoomi <oomoomi@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Using Tables from another database.
Date: Thu, 25 Jul 2002 17:32:45 +0000
Message-ID: <F260ZichUp9XghaF9c50001623e@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oomoomi@hotmail.com
Subject: Re: Using Tables from another database.
In-Reply-To: <F260ZichUp9XghaF9c50001623e@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox