RE: Backup Functions - Mailing list pgsql-sql

Hey Vijaykumar,

Thank you for the quick response.

Q) do you see the functions expected to be dumped under \df public.* of the db ? 

Response) Yes, I do see all the functions listed.

However, when tried to dump it does not include all functions.

--

-- PostgreSQL database dump

--

-- Dumped from database version 11.10

-- Dumped by pg_dump version 11.10

SET statement_timeout = 0;

SET lock_timeout = 0;

SET idle_in_transaction_session_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

SELECT pg_catalog.set_config('search_path', '', false);

SET check_function_bodies = false;

SET xmloption = content;

SET client_min_messages = warning;

SET row_security = off;

--

-- Name: public; Type: SCHEMA; Schema: -; Owner: xxx

--

CREATE SCHEMA public;

ALTER SCHEMA public OWNER TO xxx;

--

-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: xxx

--

COMMENT ON SCHEMA public IS 'standard public schema';

--

-- Name: dmc_update_row_modified_function(); Type: FUNCTION; Schema: public; Owner: dbmsowner

--

CREATE FUNCTION public.dmc_update_row_modified_function() RETURNS trigger

    LANGUAGE plpgsql

    AS $$ BEGIN IF TG_OP = 'UPDATE' THEN NEW.modified_dttm = NOW(); RETURN NEW; ELSIF TG_OP = 'INSERT' THEN NEW.created_dttm = NOW(); RETURN NEW; END IF; END; $$;

ALTER FUNCTION public.dmc_update_row_modified_function() OWNER TO dbmsowner;

--

-- PostgreSQL database dump complete

EXTERNAL