Query function arg data types ONLY (no arg names)

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Query function arg data types ONLY (no arg names)
Date: 2018-04-28 16:52:03
Message-ID: CAMa1XUjFrseK4OAo7sniOPH8ZNMXQ99da6b2U6QyVwxM5dL5nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It appears that neither pg_get_function_arguments
nor pg_get_function_identity_arguments could be used for this. I want to
get function argument data types from the catalog by ordinal position,
without the argument name.

For example, I want the same information for these 2 functions:

foo(p_1 int, p_2 text)

- {int, text}

foo(int, text)

- {int, text}

Any suggestions as to how to use the catalogs or built-in postgres
functions to query this?

Thank you!
Jeremy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2018-04-28 17:00:36 Re: Query function arg data types ONLY (no arg names)
Previous Message Justin Pryzby 2018-04-28 16:00:32 Re: [GENERAL] huge RAM use in multi-command ALTER of table heirarchy