How to open a local folder location (PLPGSQL)

I have a file stored in './mnt/data.csv' within an airflow instance.

I want to open the file in order to loop through the records.

In python I can simply do open("./mnt/data.csv") but I'm interested in how to do this in a postgres sql script.

How do I open a file in postgres procedural language PLPGSQL?

https://stackoverflow.com/questions/67220800/how-to-open-a-local-folder-location-plpgsql April 23, 2021 at 05:10AM