Re: Using tables in other PostGreSQL database

My bad.

1. I work at a Manufacturing plant.
2. We identify different process steps using numbers along with a short
and long description
3. For a part we manufacture the system identifies SOME properties of
said part. Things like nuper of process steps, part name, part family,
and other items.
4. Using various other properties, the total of all process steps of
said part being one, I can identify what kind of metals said part uses
by referencing the "SHORT DESC" of the process steps.

Now on it's own the "PROCESS STEP" is what I consider an atomic data
meaning that the if I look at it there is not a sub piece that it could
be broken down to. So when I need to store that data I place it into
it's own MSAccess Database.

However, I have a database for all of the parts my site manufactures. I
have a need to be able to extract a parts full process flow so using
some other tables which will identify and order the process steps I can
make a process flow which lists the short or long description depending
on my need.

I have another database which I need to look at the inventory ( not
caring what particular part just qty ) at a particular process step.
Now I may want to see one desc or another. However, the fact that a
part is placed in a family value of say "Microcontroller or ASIC or
EEPROM" it doesn't have any relationship to say a particular "PROCESS
STEP" hence my comment of no relation ( I guess I should have said
tenuous relation ) instead of no relation.

Now as I see it logically I have 3 different databases ( 1 for holding
atomic information about a process step, 1 for being able to list a
products manufacturing flow, and 1 that is an inventory ). So in my
logic I either have to have the "PROCESS STEP" data in 2 databases or I
have it in one database and other databases just "LINK" to it.

Now with the discussion in this thread I'm beginning to see that the
term "LINK" is kind of MSAccess unique.

So yes I use multiple databases. ( 4 of which are )
1. Lists all pats I manufacture ( includes general summary information
like cycle time, number of process', number of critical process', number
of metals used, etc... )
2. Lists all process steps at my site, and indicates if it is a metal
and which type, if it's a critical process or not, which functional area
said process resides )
3. Lists the substeps for a particular PROCESS STEP to determine how
many internal steps there are to any given process ( this can be
dependent on the part )
4. Lists IF a part has an "ENGINEERING" restriction to a particular
tool and which tool part has to run on at a given Process Step.

I guess the biggest problem is trying to describe something in terms
that all can understand. On a forum like this most "CONTRIBUTORS" those
who answer questions speak a language that the typical novice poster
doesn't use or understand. So when the question is posed there is a
disconnect between poster and responder. So I'm hoping that I've been
able to adequately clear the air. If not it's always fun to try.

-----Original Message-----
From: Adrian Klaver [mailto:aklaver(at)comcast(dot)net]
Sent: Tuesday, April 01, 2008 8:30 AM
To: pgsql-general(at)postgresql(dot)org
Cc: Pettis, Barry
Subject: Re: [GENERAL] Using tables in other PostGreSQL database

On Monday 31 March 2008 4:20 am, Pettis, Barry wrote:
> 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.

Now I am confused. If the data has no relationship to other data why do
you
need to link to it? Second in your original post you said you where
trying to
pull data from multiple Postgres databases now you say you are using
multiple
Access databases.

>
> 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
>

> http://www.postgresql.org/mailpref/pgsql-general

--
Adrian Klaver
aklaver(at)comcast(dot)net