<database>.<table_name>

From: "Sivagami (dot)" <sivagami(at)worlddata(dot)com>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: <database>.<table_name>
Date: 2000-10-27 21:03:54
Message-ID: 005901c04059$6a6784d0$43c0f4d1@worlddata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I tried:

SELECT * FROM DB1.MY_TABLE;

from DB2 and it did not like the syntax. I assume that you cannot select across database/schemas.

Is this correct?

Shiva

Browse pgsql-sql by date

  From Date Subject
Next Message KuroiNeko 2000-10-28 03:54:35 Re: benchmarks
Previous Message Tom Lane 2000-10-27 14:39:32 Re: except on nulls?