Jun Yang wrote:
Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that contains the common columns to all tables. But is there a way to add a super table to existing tables for them to inherit from? Thanks! Jun
as long as the parent and child has the same table struct, yes. use: alter table child inherit newparent; -Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
