Re: List Functions and Code

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: List Functions and Code
Date: 2011-07-30 08:48:24
Message-ID: CA+U5nM+=um7dy4nzHDAwLUriSWSrG75iaO18ZJ7J8p-nMG4OBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 28, 2011 at 2:31 PM, Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz> wrote:

> I want to search and list all the functions in a database that reference a
> particular table within its code. Is there a way to do this?

No, because functions can execute SQL dynamically.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Deniz Atak 2011-07-30 09:01:24 ERROR: could not read block 4707 of relation 1663/16384/16564: Success
Previous Message Gavin Flower 2011-07-30 08:31:45 Re: Finding referecing and referenced tables, adaptation from David Fetter's solution