Re: DELETE FROM pg_description WHERE ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DELETE FROM pg_description WHERE ...
Date: 2011-04-23 03:21:58
Message-ID: 1237.1303528918@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Erwin Brandstetter <brsaweda(at)gmail(dot)com> writes:
> However, I have a database with dozens of schemas and hundreds of
> tables. There is a bunch of useless comments on columns I want to get
> rid of, scattered all across the db. The fastest & easiest way would
> be:

> DELETE FROM pg_description WHERE description = 'My very special
> totally useless comment.';

> AFAICS, there are no side-effects. Are there any?

It's safe enough, as long as you don't delete the wrong comments.
There's no hidden infrastructure for a comment.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message bo gu 2011-04-23 09:40:59 a warm standby takes over, hot standby does not catch up
Previous Message Tom Lane 2011-04-23 03:17:48 Re: select for update