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

[Jun Yang <jyang825@xxxxxxxxx>]

On Sat, Aug 1, 2009 at 7:53 PM, David Fetter <david@xxxxxxxxxx> 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.

Cheers,
David.

Jun

 

--
David Fetter <david@xxxxxxxxxx> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@xxxxxxxxx

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