Re: How to delete all operators

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Martin Pohl <Nilpherd(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to delete all operators
Date: 2006-04-03 17:09:11
Message-ID: C6121D81-9FB1-44C2-B61B-71E0BC5AE661@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mar 31, 2006, at 5:17 AM, Martin Pohl wrote:
> Is there any way to drop all operators (given they are all in the
> schema
> "public) in a script?
>
> Something like (pseudocode):
> Drop all operators in schema "public"

Nope, though information_schema or the newsysviews project on
pgFoundry might make it easier to get that list of operators.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Condit 2006-04-03 17:24:17 Re: pgsql and streams
Previous Message Jim Nasby 2006-04-03 17:06:03 Re: FAQ 1.1