Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group