Detecting functions installed by an extension

From: Benjie Gillam <benjie(at)jemjie(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Detecting functions installed by an extension
Date: 2018-06-17 08:05:21
Message-ID: CAMThMzG0TmH9a8bLn4jViMnf-Og_cXk+2_q3O9N6vtv3Hrrxpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings!

How can I tell, using the system catalog or information schema, if a
function/procedure was created by an extension as opposed to by the user
(i.e. would be dropped if you performed "DROP EXTENSION")? So far I've
looked at the `pg_extension` table, which lists the class IDs of
configuration tables but doesn't mention procedures. I've looked at
`pg_proc` but that doesn't seem to contain the information. I've also
scanned over various other system catalogues but with no luck. Is this
information available in one of the system catalogs? Does PostgreSQL itself
track this information so that it can perform cleanup, or does it expect
the extension to clean up after itself?

Thank you for your time,

Benjie.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vik Fearing 2018-06-17 08:26:23 Re: Detecting functions installed by an extension
Previous Message Amit Kapila 2018-06-17 05:15:35 Re: Slow planning time for simple query