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

From William Leite Araújo
Subject Re: How to delete all operators
Date
Msg-id bc63ad820604030801k249bb97el46ba70916f9ef3ba@mail.gmail.com
Whole thread Raw
In response to How to delete all operators  (" Martin Pohl" <Nilpherd@gmx.net>)
List pgsql-general
      You can make a function to do this.

  CREATE FUNCTION drop_operators(text) RETURNS BOOL AS
  $$
  DECLARE
    op record;
  BEGIN
    FOR op IN SELECT opname
                     FROM pg_operator as o left join pg_namespace as n on (o.oprnamespace = n.oid)
                     WHERE nspname = $1
    LOOP
      EXECUTE 'DROP OPERATOR '||quote_literal(op.opname)|| ';';
    END LOOP;
    RETURN TRUE;
  END;
 
$$ LANGUAGE 'plpgsql' IMMUTABLE;

  And so: SELECT drop_operators( 'public');

On 3/31/06, Martin Pohl <Nilpherd@gmx.net> wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly



--
William Leite Araújo

pgsql-general by date:

Previous
From: "Tomi NA"
Date:
Subject: Re: database design questions
Next
From: "Merlin Moncure"
Date:
Subject: Re: pl/pgsql uniq varchar[] sort?