DDLs of a Function - Mailing list pgsql-admin

From pratmeht
Subject DDLs of a Function
Date
Msg-id 1576558801119-0.post@n3.nabble.com
Whole thread Raw
Responses Re: DDLs of a Function  (Omkar Dhorge <omkardhorge@gmail.com>)
Re: DDLs of a Function  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Hi Postgres Community,

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 ?

Regards,
Pratik Mehta



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html



pgsql-admin by date:

Previous
From: Min Wang
Date:
Subject: RE: PostgreSQL 11 sends shared secret to RADIUS server in all low case
Next
From: pratmeht
Date:
Subject: Dependent Objects on Table