Re: PL/pgSQL HTTP Request

Hi Pavel,

We would like to use with Google Cloud Sql where third party extensions are
not supported.

On Fri, Dec 7, 2018, 9:55 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com wrote:

> Hi
>
> pá 7. 12. 2018 v 14:48 odesílatel Sathish Kumar <satcse88(at)gmail(dot)com>
> napsal:
>
>> Hi Team,
>>
>> Do PL/pgSQL support to create a function to make HTTP request. We have a
>> requirement to send data to external server from Postgres DB using
>> HTTP/HTTPS Post Method.
>>
>
>
> Surely It doesn't support it. You can use some untrusted language - but it
> is not safe.
>
> you can use https://github.com/pramsey/pgsql-http extension. It is much
> better, but still it not good idea. Stored procedures are perfect for work
> inside database. Communication with outer world is not good
>
> a) outer world is not transactional
> b) outer world is too slow.
>
> This is task for application (communication) server.
>
> Regards
>
> Pavel
>