How can we read environment variable in postgresql

Question

I have a postgresql function where I want to use get user defined environment variable. Is there any default function to get the environment variable directly ?

Potentially useful related question.

Nagev
– Nagev

2022-02-06 15:15:28 +00:00
Commented Feb 6, 2022 at 15:15 — Nagev
– Nagev, Commented Feb 6, 2022 at 15:15

Laurenz Albe · Accepted Answer · 2020-06-10 07:05:44Z

1

Since a function is running on the database server, you would get the environment of the database server process (I wonder if that is what you want). This should be restricted to superusers (or perhaps the pg_execute_server_program role).

There is no standard function for this, probably because it is mostly useless, but it should be easy to write a function in C, PL/PerlU or PL/PythonU to do that.

answered Jun 10, 2020 at 7:05

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shadi Over a year ago

This SO answer gives access to the general server environment (not the database server process environment)

pifor · Accepted Answer · 2020-06-10 07:06:41Z

0

No there is no SQL function available to do this.

But it should not be complicate to do using https://www.postgresql.org/docs/12/xfunc-c.html.

answered Jun 10, 2020 at 7:06

pifor

7,9722 gold badges11 silver badges18 bronze badges

Collectives™ on Stack Overflow

How can we read environment variable in postgresql

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related