Re: DELETE FROM pg_description WHERE ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Erwin Brandstetter <brsaweda(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: DELETE FROM pg_description WHERE ...
Date: 2011-04-24 16:27:46
Message-ID: 22836.1303662466@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On Fri, Apr 22, 2011 at 5:26 PM, Erwin Brandstetter <brsaweda(at)gmail(dot)com> wrote:
>> DELETE FROM pg_description WHERE description = 'My very special
>> totally useless comment.';

> Why would you *not* use the COMMENT command for that?

If what he wants is to drop comments containing a particular string,
COMMENT isn't an especially easy way to do it.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Hornsby 2011-04-24 22:21:27 Scaling
Previous Message Simon Riggs 2011-04-24 15:25:09 Re: DELETE FROM pg_description WHERE ...