Using Tables from another database.

From: Rogério Baldini das Neves <baldini(at)infoquest(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Using Tables from another database.
Date: 2002-07-25 13:36:09
Message-ID: 000b01c233e0$3d1b85e0$0301a8c0@infoquest.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Treat 2002-07-25 14:26:49 Re: how do I change regional setting for dates?
Previous Message Viacheslav Kovalchuk 2002-07-25 12:57:15 use of client-side \lo_import and \lo_export commands