How to delete all operators

Поиск
Список
Период
Сортировка
От Martin Pohl
Тема How to delete all operators
Дата
Msg-id 28786.1143800259@www062.gmx.net
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: PANIC: heap_update_redo: no block
Следующее
От: "David Bernal"
Дата:
Сообщение: pgsql continuing network issues