accessing postgres conf from stored procedure
Is it possible to access postgres configuration from
a C stored procedure ?
I need to leverage memory usage and I'd use postgres configuration
rather then a compile-time define.
Is there such a configuration, if access is possible ?
--strk;
you can use show xxx to show configuration values
http://www.postgresql.org/docs/7.4/interactive/sql-show.html
Dave
On 27-Jun-05, at 6:56 AM, strk wrote:
Show quoted text
Is it possible to access postgres configuration from
a C stored procedure ?I need to leverage memory usage and I'd use postgres configuration
rather then a compile-time define.Is there such a configuration, if access is possible ?
--strk;
---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend
On Mon, Jun 27, 2005 at 08:55:50AM -0400, Dave Cramer wrote:
you can use show xxx to show configuration values
http://www.postgresql.org/docs/7.4/interactive/sql-show.html
No direct interface for shared libs ?
--strk;
On Mon, Jun 27, 2005 at 04:37:11PM +0200, strk wrote:
On Mon, Jun 27, 2005 at 08:55:50AM -0400, Dave Cramer wrote:
you can use show xxx to show configuration values
http://www.postgresql.org/docs/7.4/interactive/sql-show.html
No direct interface for shared libs ?
I don't know if it's fair game, but GetConfigOptionByName() (declared
in utils/guc.h) appears to work. Can any of the developers comment
on whether it's appropriate for user-defined code to call this
function?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/