How to specify the location of nadgrids in postgres with postgis extension?

There is a postgis function called ST_Transform to transform the coordinates to a different spatial reference system. This function receives the original geometry (from a table), a set of proj parameters and a srid value. Among the proj parameters, there is a parameter which is a file which is used by proj.

For instance: SELECT id, ST_Transform( geom, '+proj=tmerc +lat_0=0 +lon_0=15 +k=0.9996 +x_0=2520000 +y_0=0 +ellps=intl +nadgrids="/tmp/example.gsb" +units=m +no_defs', 6708) as geom FROM test.Test

The file is /tmp/example.gsb, and the file can be anywhere in the system but it should be accessible by the program. Is there a way to download a file from a S3 bucket locally, even to a temp folder or a specific folder.

I saw that is possible for SQLServer:

The following example shows the stored procedure to download files from S3. exec msdb.dbo.rds_download_from_s3 @s3_arn_of_file='arn:aws:s3:::bucket_name/bulk_data.csv', @rds_file_path='D:\S3\seed_data\data.csv', @overwrite_file=1;