Re: can I get a bit more attribute out of \dt directive? - Mailing list pgsql-admin

From Harald Fuchs
Subject Re: can I get a bit more attribute out of \dt directive?
Date
Msg-id pu1vkx2dff.fsf@srv.protecting.net
Whole thread Raw
In response to can I get a bit more attribute out of \dt directive?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Responses Re: can I get a bit more attribute out of \dt directive?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
In article <dcc563d10910201344t6ec78e82hb67aaac471279d89@mail.gmail.com>,
Scott Marlowe <scott.marlowe@gmail.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?

pgsql-admin by date:

Previous
From: "Hans Guijt"
Date:
Subject: Range-based clustering?
Next
From: Scott Mead
Date:
Subject: Re: How to troubleshoot a halted postgres 8.3 ?