Re: Is it possible to call Postgres directly?

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