Re: can I get a bit more attribute out of \dt directive?

From: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: can I get a bit more attribute out of \dt directive?
Date: 2009-10-21 11:29:08
Message-ID: pu1vkx2dff.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <dcc563d10910201344t6ec78e82hb67aaac471279d89(at)mail(dot)gmail(dot)com>,
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:

> Do you mean when the table was modified (i.e. alter table add column)
> or when the data in the table was changed? If it's when the table was
> changed, the easiest way is to store that in the comment for the table
> whenever you alter it.

Highly interesting. I put an "EXECUTE 'COMMENT ON TABLE ...'" into an
AFTER INSERT OR UPDATE OR DELETE trigger, and this indeed works. Does
anyone see a drawback in modifying a table comment very often?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2009-10-21 12:48:32 Re: How to troubleshoot a halted postgres 8.3 ?
Previous Message Hans Guijt 2009-10-21 10:32:40 Range-based clustering?