Skip to content

Instantly share code, notes, and snippets.

@jeff

jeff/looking_at_compile_composite_attr.sql Secret

Created December 5, 2017 16:45
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 jeff/f225fb4c054d8c3e4f7593af4b7934d4 to your computer and use it in GitHub Desktop.
Save jeff/f225fb4c054d8c3e4f7593af4b7934d4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
looking_at_compile_composite_attr.sql
-- show namespace of function and function return type for compile_composite_attr
SELECT pg_proc.oid, pg_namespace.nspname, proname, type_namespace.nspname, pg_type.typname
FROM pg_proc
JOIN pg_namespace ON pg_proc.pronamespace = pg_namespace.oid
JOIN pg_type ON pg_proc.prorettype = pg_type.oid
JOIN pg_namespace AS type_namespace ON pg_type.typnamespace = type_namespace.oid
WHERE proname = 'compile_composite_attr';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment