postgresql.information_schema.ROUTINES.sql Maven / Gradle / Ivy
SELECT
NULL AS ROUTINE_CATALOG,
ROUTINE_SCHEMA,
ROUTINE_NAME,
SPECIFIC_NAME,
ROUTINE_BODY,
ROUTINE_DEFINITION
FROM
INFORMATION_SCHEMA.ROUTINES
ORDER BY
ROUTINE_CATALOG,
ROUTINE_SCHEMA,
ROUTINE_NAME