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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: can I get a bit more attribute out of \dt directive?
Date: 2009-10-21 13:45:00
Message-ID: 27072.1256132700@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com> writes:
> 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?

As long as pg_description gets vacuumed or autovacuumed often enough,
it should be no worse than frequent updates in any other table.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2009-10-22 00:39:40 Is it possible to have psql ignore the line I am typing?
Previous Message Scott Mead 2009-10-21 12:48:32 Re: How to troubleshoot a halted postgres 8.3 ?