Hi,
I am not an expert but in object conception, a design pattern
exists for the case you describe. I don't remember which
one. The idea is to add an attribute that references the job
of the employee. The inheritance is not on the side of the
employee but on the side of the job. So if
Hello,
there is the view "columns" in the schema "information_schema" that
can give you most of the informations you need
( for PosgreSQL version >= 7.4.8 if I'm right).
SELECT *
FROM information_schema.columns
WHEREtable_name = 'mytable';
See
http://www
Doug Y a écrit :
I can't figure out an efficient way to do this. Basically I had a
typical 3-tier relationship:
(Employee -> Department -> Division)
However, at some point the need to move employees arose, but instead
of changing the key in the emp table, we now have an over-ride table,
so a his
