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

From
Subject Re: Is it possible to call Postgres directly?
Date
Msg-id 00a501d19b92$f8a1f870$e9e5e950$@andl.org
Whole thread Raw
In response to Re: Is it possible to call Postgres directly?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Is it possible to call Postgres directly?
Re: Is it possible to call Postgres directly?
List pgsql-general
> > 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?

The aim is to execute Andl code at the top level, not inside SQL. So instead
of:

>>>SELECT * FROM AndlFunc(args);

I need

>>>AndlFunc(args)

> 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.

No, SPI is quite low enough level for me. I really don't want or need to go
lower than that.

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?

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org




pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: Re: Update field to a column from another table
Next
From: Karsten Hilbert
Date:
Subject: Re: Function PostgreSQL 9.2