Postgres Pro
Downloads
Home   >   mailing lists

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

From Rogério Baldini das Neves
Subject Using Tables from another database.
Date
Msg-id 000b01c233e0$3d1b85e0$0301a8c0@infoquest.com.br
Whole thread Raw
Responses Re: Using Tables from another database.
List pgsql-sql
Tree view
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
 
 

pgsql-sql by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: Last record
Next
From: "Nathan Suderman"
Date:
Subject: queries got slower using 7.1.3