Re: Using Tables from another database. - Mailing list pgsql-sql

From Reinoud van Leeuwen
Subject Re: Using Tables from another database.
Date
Msg-id q4e0kugu9kr5qtdd6nh4oed7tb7mfo9kn1@4ax.com
Whole thread Raw
In response to Using Tables from another database.  (Rogério Baldini das Neves <baldini@infoquest.com.br>)
Responses Re: Using Tables from another database.  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini@infoquest.com.br
(Rogério Baldini das Neves) wrote:

>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??

This is possible in Sybase or Microsoft SQL server, not in Postgresql
(AFAIK)

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen       reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: problem with plpgsql trigger function: parse error near ""
Next
From: ROUWEZ Stephane
Date:
Subject: Change size of a field