Emi Lu <em...@encs.concordia.ca> writes: > (1) Is possible that I could change the column of a table that is > defined by Inherits?
> e.g., t1(col1, col2, col3); create table tx(colx) Inherits (t1) > I'd like to get tx shown as (col1, colx, col2, col3). No, you don't really have a lot of control over that. It'll stick non-inherited columns at the end. > (2) Logically, I have a table inherited from two other tables, but no > more other columns. Will it not be encouraged to do so? > e.g., t1 (col1... coln) > t2 (col1... coln) > create t3() Inherits (t1, t2) without OID Sure, that's allowed. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql