Re: How can I retrieve an info about function arguments ? - Mailing list pgsql-sql

From Bhuvan A
Subject Re: How can I retrieve an info about function arguments ?
Date
Msg-id Pine.LNX.4.44.0210261131190.2024-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to How can I retrieve an info about function arguments ?  ("Zuev Dmitry" <envoy1@chat.ru>)
List pgsql-sql
> I need to retreive full set of info about argument and return types (for
> variable length too).

test_db=>\df+ my_func
will serve your need :(

> How I can get it from system catalog ?
pg_proc.pronargs    -- count of arguments
pg_proc.proargtypes -- oid(s) of pg_type for appropriate arguments

regards,
bhuvaneswaran



pgsql-sql by date:

Previous
From: Tim Perdue
Date:
Subject: Re: Foreign character struggles
Next
From: "Josh Berkus"
Date:
Subject: Re: datediff?