Re: Is it possible to call Postgres directly? - Mailing list pgsql-general

From John R Pierce
Subject Re: Is it possible to call Postgres directly?
Date
Msg-id 57187435.4050303@hogranch.com
Whole thread Raw
In response to Re: Is it possible to call Postgres directly?  (<david@andl.org>)
List pgsql-general
On 4/20/2016 10:59 PM, david@andl.org wrote:
> So the question is: Can a C program link to the Postgres DLL and call SPI
> directly, rather than through a language function?
>
> Is there a way to launch a Thrift server or a Web server and call SPI
> directly?


no, those can only be called from the context of a function that was
called from SQL as part of a query.

if you want to completely replace SQL as the query language, why don't
you just provide your own Andl API, and have it run in the client
context and execute SQL queries via the normal libpq style API ?

you could still use pl/andl for things like triggers and such but not
for direct client queries.


--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: martin.kamp.jensen@schneider-electric.com
Date:
Subject: Invalid data read from synchronously replicated hot standby
Next
From: Sachin Kotwal
Date:
Subject: Re: error while installing auto_explain contrib module