Postgres Pro
Downloads
Home   >   mailing lists

How to delete all operators - Mailing list pgsql-general

From Martin Pohl
Subject How to delete all operators
Date
Msg-id 28786.1143800259@www062.gmx.net
Whole thread Raw
Responses Re: How to delete all operators  ("William Leite Araújo" <william.bh@gmail.com>)
Re: How to delete all operators  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-general
Tree view 
Hi,

I have a database with operators and functions in plpgsql.
To update the data to the latest version I would like to drop all operators.
There might be some, that I don't know. I don't have access to the database,
but have to write a script, that will update the data.

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"

Thanks in advance for answers

--
E-Mails und Internet immer und �berall!
1&1 PocketWeb, perfekt mit GMX: http://www.gmx.net/de/go/pocketweb

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: PANIC: heap_update_redo: no block
Next
From: "David Bernal"
Date:
Subject: pgsql continuing network issues