Skip to content

Instantly share code, notes, and snippets.

@gusdewa

gusdewa/get_all_functions.sql

Last active June 16, 2021 05:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gusdewa/0cf3bf883846ebba8aa96e3992a46975 to your computer and use it in GitHub Desktop.
Save gusdewa/0cf3bf883846ebba8aa96e3992a46975 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres List All Functions with Parameters
Raw
get_all_functions.sql
SELECT
routines.routine_name,
parameters.data_type,
parameters.ordinal_position
FROM
information_schema.routines
LEFT JOIN information_schema.parameters ON
routines.specific_name = parameters.specific_name
WHERE
routines.specific_schema = 'public'
ORDER BY
routines.routine_name,
parameters.ordinal_position
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment