Hello All,
I was trying to find some way, to list out all argument details in all functions in postgre(input parameter names, types and mode - in/out).
I found one solution -
------------------------------------------------------------------------------------------------------
select r.routine_schema,b.typname,t.* from
(
select proname,proallargtypes[idx] argType, proargnames[idx] argName,proargmodes[idx] argMode
from pg_proc a
inner join generate_series(1,50)idx on 1 = 1
-- is this correct way, i dont know.
)t
inner join pg_type b on b.typelem = t.argType
inner join information_schema.routines r on r.routine_name = t.proname
where t.argType is not null
order by r.routine_schema,t.proname
--------------------------------------------------------------------------------------------
Please suggest, if some better way is available of achieving this.
Also, i want to know the way i am getting type of argument is right or not?
Background - We have migrated one oracle database to postgre. Now from .Net for coding , we need a list of all functions and their types.
Thanks in advance
Regards,
Venkat
=====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
