Postgres Pro
Downloads
Home   >   mailing lists

Re: How to delete all operators - Mailing list pgsql-general

From Jim Nasby
Subject Re: How to delete all operators
Date
Msg-id C6121D81-9FB1-44C2-B61B-71E0BC5AE661@pervasive.com
Whole thread Raw
In response to How to delete all operators  (" Martin Pohl" <Nilpherd@gmx.net>)
List pgsql-general
Tree view 
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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: PSQL Data Type: text vs. varchar(n)
Next
From: Jim Nasby
Date:
Subject: Re: FAQ 1.1