This is what I want to do: To refer to another database, like I can do
it in MySQL. After adding a schema with database name and refering to it
from another database I get:
ERROR: schema "test" does not exist
Adding the database name:
osm_de=# select * from test.test.newt;
ERROR: cross-database references are not implemented: "test.test.newt"
Could be very simple, if it would be like in MySQL ;) To be completely
in context of a schema - so that I can use all tables without the prefix
- I have to reset the search_path very often. This is probably not very
elegant, but will be my solution then ...
John R Pierce schrieb:
Andreas Kalsch wrote:
Will it decrease performance to refer to other schemas?
no. the schemas are simply two namespaces in the same database.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
