Wow seems like this post took on a life of it's own. All I wanted to do was to be able to use a table that someone else has all ready created. Seems like somewhere someone mentioned a DBA ( which I'm assuming to be "Database Administrator" ) well as far as I know we don't have one though I wish we did. The basis of my question comes from the fact that I currently use "Multiple" access databases. Each database contains 1 piece of information ( information that on it's own has no relationship to other data ), but information in other databases will use items from it in it. Hence in MSAccess I "LINK" the tables in. Which I know is nothing more than a connection. I wish I could say that I knew with certainty what schemas are or 2PC is. Would be nice if I had exposure to other databases as well. I'm sure that I'd have the same questions about MSft's SQL server. But I thank the forum here for all the input. Regards, Barry Pettis CSO Atmel Corp Project Tech -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Daniel Verite Sent: Monday, March 31, 2008 3:36 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Using tables in other PostGreSQL database Scott Marlowe wrote: > > > Even in Oracle you don't have cross db queries. > > > > On the contrary you do. You can refer to objects in another database by > > OBJECT_NAME@DBLINK_NAME, very useful to mix local and remote data in no > > time. DBLINK_NAME represents a connection to another database. > > What you don't have is OTHERDB.OBJECT_NAME to refer to a different > > database within the same instance, because there is only one database > > in an Oracle instance. > > What you are talking about are cross schema references, not cross db. No I'm definitively referring to cross db, not cross schema. See this piece from Oracle documentation: http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/sql_elem ents009.htm#i27761 > Oracle instances can have > 1 database, it's just not that common. I > know this because we had an internal instance at the last company I > worked at that had 2 databases in it, each with their own schemas. Or > maybe they somehow had two instances of oracle running on the same > box. CREATE DATABASE is to Oracle what initdb is to PG, it's something you do once per instance. So no, an Oracle instance doesn't have >1 databases, just like a PG instance doesn't have >1 data directories. Regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
