Simon Riggs writes:
> On Fri, Apr 22, 2011 at 5:26 PM, Erwin Brandstetter
> 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 particul
On Fri, Apr 22, 2011 at 5:26 PM, Erwin Brandstetter wrote:
> Hi!
>
> It is generally not advisable to write to system catalogs directly ...
>
> 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, scatte
On 23.04.2011 05:21, Tom Lane wrote:
Erwin Brandstetter 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_descrip
Erwin Brandstetter 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
Hi!
It is generally not advisable to write to system catalogs directly ...
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
