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] argModefrom pg_proc ainner 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.argTypeinner join information_schema.routines r on r.routine_name = t.pronamewhere 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 advanceRegards,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