Using ENV variables for Postgres (or any other database) query

[xpertmind]

When I'm using Postgres connector as input, the connection env variables are working.

How to use env variables in SQL query?

i.e

select * from {os.getenv('MY_TABLE')} 
where {os.getenv('MY_FIELD')}  = {os.getenv('SOME_VALUE')}  
order by {os.getenv('SORTED_BY')} ; 

Btw. thanks for the tool, it's really great. I created a short Dockerfile to use it as container, can be found here:
README.md

[tgourdel]

Hi @xpertmind,

Quick confirmation, you mean the SQL Query text box inside a Postgres component?

If so, haven't tested it but this looks like how it should work. I'll have to look into it :)

[xpertmind]

Hi @tgourdel,

yes, exactly.

This is the error message:

Execution failed on sql '
select * from {os.getenv('MY_TABLE')}
order by id;

': syntax error at or near "{"
LINE 2: select * from {os.getenv('MY_TABLE')}
^