0

I have this function in postgresSQL and I need some help to take them from enviroment.

Adding Vars in DockerFile

CREATE OR REPLACE FUNCTION prc_get_connstr()
RETURNS TEXT AS
$$
DECLARE
  res TEXT;
  SRC_ADDR varchar(50) := `echo ${SRC_ADDR_CRD:-noaddr}`;
  SRC_PORT varchar(50) := `echo ${SRC_PORT_CDR:-noport}`;
  SRC_DB varchar(50) := `echo ${SRC_DB_CDR:-nodb}`;
  SRC_USR varchar(50) := `echo ${SRC_USR_CDR:-nouser}`;
  SRC_PASS varchar(50) := `echo ${SRC_PASS_CDR:-nopass}`;
BEGIN
  RETURN 'dbname=SRC_DB host=SRC_ADDR port=SRC_PORT user=SRC_USR password=SRC_PASS connect_timeout=5';
END;
$$
LANGUAGE 'plpgsql';

When I deploy it doesn't work

You are now connected to database "cdr" as user "postgres".
CREATE EXTENSION
CREATE FUNCTION
psql:/docker-entrypoint-initdb.d/2_cdr_trigger.sql:31: ERROR:  syntax error at or near "$"
LINE 6:   SRC_ADDR varchar(50) := `echo ${SRC_ADDR_CRD:-noaddr}`;

What i have to do to declare de enviroment vars.

0 Answers0