| From: | j(dot)konzack(at)arcor(dot)de |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | CREATE VIEW question... |
| Date: | 2002-05-01 19:53:06 |
| Message-ID: | 4590508.1020282786645.JavaMail.ngmail@mx09.arcor-online.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello there...
I have two databases, called db1 an db2. Database db1 contains a table
called memberlist.
Now I will create a view, called members, in database db2 (containig data
from table memberlist) with the following query:
CREATE VIEW members AS SELECT * FROM db1.memberlist;
->>> this error is displayed: ERROR; parser: error at or near "."
How can I create a view in one database with data from a second/different
database?
Jan Konzack
-----------------------------------------------------------------------
Riester-Rente - Kassieren Sie das Geld vom Staat:
Zum Förderungsrechner! http://www.arcor.de/home/redir.php/riesterrente
-----------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2002-05-01 20:51:27 | Re: CREATE VIEW question... |
| Previous Message | Gary Stainburn | 2002-05-01 17:29:34 | problem with update from subselect |