From: | Peter Harvey <pharvey(at)codebydesign(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | INHERIT |
Date: | 2001-09-09 15:08:56 |
Message-ID: | 3B9B8608.D3E11D1E@codebydesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
If I try to get the columns from pg_attribute using the oid of a child
table created with INHERIT I get its columns AND all of its inherited
columns.
How do I just get the columns added by the child table?
I figure I could check each column to see if they also exist in
pg_attribute under a parent table but I figure there must be an
easier/faster way? Another pg_* table perhaps? Besides; I am not certian
this would work if there is a common column between a child and one of
its parents (if that is even allowed)?
As usual, any help would be greatly appreciated.
Peter
BTW: I checked pg_dump source and did not see an answer.
--
+---------------------------
| Data Architect
| your data; how you want it
| http://www.codebydesign.com
+---------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Buttafuoco | 2001-09-09 17:49:10 | |
Previous Message | Rene Pijlman | 2001-09-09 14:46:30 | Re: [HACKERS] Troubles using German Umlauts with JDBC |