Skip to content

Instantly share code, notes, and snippets.

@princejoseph
Created April 17, 2019 17:15
Show Gist options
  • Save princejoseph/b7f1786ff358dd60d2cef7a685c609be to your computer and use it in GitHub Desktop.
Save princejoseph/b7f1786ff358dd60d2cef7a685c609be to your computer and use it in GitHub Desktop.
CREATE FUNCTION public.get_xmlbinary() RETURNS character varying
LANGUAGE plpgsql
AS $$
DECLARE
xmlbin varchar;
BEGIN
select into xmlbin setting from pg_settings where name='xmlbinary';
RETURN xmlbin;
END;
$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment