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@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. 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@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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general