Re: DDLs of a Function

On Mon, 2019-12-16 at 22:00 -0700, pratmeht wrote:
> We want to drop a table and recreate it. As we all know, dropping a table
> even drops the dependent objects like views, MVs, functions. I wanted your
> help to get the DDL of the (dependent) function before we can drop the
> table. Once the dropped table is being recreated, this DDL will be helpful
> to recreate that function.
> 
> We found a way to get the DDL of the Views and MVs, but not for function! :(
> Can someone please help ?

You can use "pg_get_functiondef":

SELECT pg_get_functiondef('pg_get_functiondef'::regproc);

                      pg_get_functiondef                       
---------------------------------------------------------------
 CREATE OR REPLACE FUNCTION pg_catalog.pg_get_functiondef(oid)+
  RETURNS text                                                +
  LANGUAGE internal                                           +
  STABLE PARALLEL SAFE STRICT                                 +
 AS $function$pg_get_functiondef$function$                    +
 
(1 row)

This article contains something about view dependencies:
https://www.cybertec-postgresql.com/en/tracking-view-dependencies-in-postgresql/

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com