Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE or replace FUNCTION base."getTypes"(IN "pSchema" character varying) RETURNS SETOF pg_type AS
- $BODY$
- SELECT
- --pg_type.oid,
- pg_type.*
- FROM pg_type
- JOIN pg_namespace ON typnamespace = pg_namespace.oid
- WHERE
- nspname = $1
- ;$BODY$
- LANGUAGE sql VOLATILE;
- select * from base."getTypes"('schema');
- -- how to get oid of result row from this function???
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement