Andreas Kalsch wrote:
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 ...
if it would be "like in mysql", it wouldn't be postgresql.
in postgresql, if you have several namespaces that you want to use
together, use different namespaces in the same database.
now, if you want to 'use all tables without prefix', then why would you
use more than one database or schema or whatever?
the only alternative to access an alternate database within a query is
by using the contributed db_link module, and this is quite
restrictive. since the two databases are completely seperate,
operations like joins are very expensive.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
