Re: Question About PostgreSQL Extensibility - Mailing list pgsql-general

From felix.quintgz@yahoo.com
Subject Re: Question About PostgreSQL Extensibility
Date
Msg-id 1339439671.8033809.1697205336290@mail.yahoo.com
Whole thread Raw
In response to Re: Question About PostgreSQL Extensibility  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Question About PostgreSQL Extensibility
List pgsql-general
For the same reason that you can use python or perl in postgresql. It's just another language.
I have .net code running on several sql servers and to change the database to postgresql I have to reprogram them.

 On Thursday, October 12, 2023 at 09:44:08 AM GMT-4, Laurenz Albe <laurenz.albe@cybertec.at> wrote:

 On Thu, 2023-10-12 at 06:09 +0000, Sepideh Eidi wrote:
> We have some .net assemblies and in your documents, I didn’t find any support for this
> type of files that is executable in DB or not. Would you please tell me that .net
> assemblies files are executable in PostgreSQL or not? Or is there any way for calling
> assembly methods inside DB?

There is no support for that.  I guess somebody could write an extension PL/net,
and it looks like somebody already has: https://github.com/witblitz/pldotnet.
That code ptobably won't work with recent PostgreSQL releases, but it could be
a basis for you to work upon.

My big question for me is: Why on earth would you want to run .NET code inside a
database?  Why not run it on the client?

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: psql \du no more showing "member of" column
Next
From: Lele Gaifax
Date:
Subject: Re: psql \du no more showing "member of" column