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

From Tom Lane
Subject Re: Is it possible to call Postgres directly?
Date
Msg-id 27649.1461207921@sss.pgh.pa.us
Whole thread Raw
In response to Is it possible to call Postgres directly?  (<david@andl.org>)
Responses Re: Is it possible to call Postgres directly?
List pgsql-general
<david@andl.org> writes:
> I would like to be able to execute SQL queries by a direct call into
> Postgres, without going through either (1) the language call handler or (2)
> a 'wire' protocol.

What would you consider to be "directly"?  What advantage would you
hope to gain from a different API?

FWIW, it seems unlikely to me that we would consider anything much
lower-level than SPI to be an officially-supported query interface.
You could no doubt run a query by calling assorted backend functions
directly from a PL implementation, but it would be mostly on your
own head whether that worked and kept working across releases.

            regards, tom lane


pgsql-general by date:

Previous
From:
Date:
Subject: Is it possible to call Postgres directly?
Next
From: John R Pierce
Date:
Subject: Re: Is it possible to call Postgres directly?