DELETE FROM pg_description WHERE ... - Mailing list pgsql-admin

From Erwin Brandstetter
Subject DELETE FROM pg_description WHERE ...
Date
Msg-id da0a7ec9-70de-4017-a514-8d62596f13f7@x10g2000vbn.googlegroups.com
Whole thread Raw
Responses Re: DELETE FROM pg_description WHERE ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DELETE FROM pg_description WHERE ...  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
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 pg_description WHERE description = 'My very special
totally useless comment.';

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


TIA!
Erwin Brandstetter

pgsql-admin by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Reseting statistics, cluster wide
Next
From: Steve Crawford
Date:
Subject: Re: unix timestamp