Re: Scripting issues - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Scripting issues
Date
Msg-id ACFC727E-8133-49CE-84D6-26B33323EDA7@myrealbox.com
Whole thread Raw
In response to Re: Scripting issues  (postgresql@bryden.co.za)
List pgsql-general
On Jun 21, 2005, at 5:59 PM, postgresql@bryden.co.za wrote:

> One other question: Since in PostgreSQL you can have "overloaded"
> functions, how do you query the system tables for the existence of a
> particular version of the function?

The pg_proc table (which contains the functions) includes a field
that has an argument list array. You can use this to figure out which
if the one you want to drop exists.

http://www.postgresql.org/docs/8.0/interactive/catalog-pg-proc.html

Michael Glaesemann
grzm myrealbox com


pgsql-general by date:

Previous
From: postgresql@bryden.co.za
Date:
Subject: Re: Scripting issues
Next
From: Martijn van Oosterhout
Date:
Subject: Re: renumber id's in correct order (compact id's)