Re: Using Tables from another database.

From: Reinoud van Leeuwen <reinoud(dot)v(at)n(dot)leeuwen(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using Tables from another database.
Date: 2002-07-25 17:43:30
Message-ID: q4e0kugu9kr5qtdd6nh4oed7tb7mfo9kn1@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini(at)infoquest(dot)com(dot)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(dot)v(at)n(dot)leeuwen(dot)net
http://www.xs4all.nl/~reinoud

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-07-25 18:06:22 Re: problem with plpgsql trigger function: parse error near ""
Previous Message Bruno Wolff III 2002-07-25 17:36:32 Re: Using Tables from another database.