Re: Can I add a super table to existing tables?

On Sat, Aug 01, 2009 at 08:10:02PM -0700, Jun Yang wrote:
> On Sat, Aug 1, 2009 at 7:53 PM, David Fetter <david(at)fetter(dot)org> wrote:
> > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote:
> > > Hi all,
> > >
> > > I want to add some common columns to all of my tables.
> >
> > Your case may be very special, but offhand, this sounds like a
> > very bad idea. What task is it you're trying to accomplish?
>
> Very simple. I have columns update_by and updated_at that I want
> every table to have but don't want to add them one by one.

This sounds like you're working your way up to some kind of logging
system :)

Check out the tablelog <http://pgfoundry.org/projects/tablelog/>

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate