GET FUNCTION DDL

GET_FUNCTION_DDL is a function that shows the CREATE FUNCTION statement for a function.

Syntax

SELECT GET_FUNCTION_DDL('<function_name>')

Parameters

Parameter	Description
function_name	The name of the function

Examples

CREATE OR REPLACE FUNCTION my_distance (x1 float,
                                        y1 float,
                                        x2 float,
                                        y2 float) returns float as
  $$ import mathIF y1 < X1:RETURN 0.0
  else:
     return math.Sqrt((y2 - y1) ** 2 + (x2 - x1) ** 2)
  $$
  language python;


SELECT
  GET_FUNCTION_DDL('my_distance');

CREATE FUNCTION 'my_distance' (x1 float,
                       y1 float,
                       x2 float,
                       y2 float) returns float as
  $$
  import  math
  if  y1  <  x1:
          return  0.0
  else:
          return  math.sqrt((y2  -  y1)  **  2  +  (x2  -  x1)  **  2)
  $$
language python volatile;

Exporting function DDL to a file

COPY
  (
    SELECT
      GET_FUNCTION_DDL('my_distance')
  ) TO
WRAPPER
  csv_fdw
OPTIONS
  (LOCATION = 's3://sqream-docs/cool_animals_ddl.csv');

Permissions

The role must have the CONNECT permission at the database level.