pg_config VIEW for PostgreSQL
C
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Makefile
README
pg_config.c
pg_config.sql.in
uninstall_pg_config.sql

README

/*
 * Copyright (c) 2010, PostgreSQL Global Development Group
 * ALL RIGHTS RESERVED;
 *
 * Permission to use, copy, modify, and distribute this software and its
 * documentation for any purpose, without fee, and without a written agreement
 * is hereby granted, provided that the above copyright notice and this
 * paragraph and the following two paragraphs appear in all copies.
 *
 * IN NO EVENT SHALL THE AUTHOR OR DISTRIBUTORS BE LIABLE TO ANY PARTY FOR
 * DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
 * LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
 * DOCUMENTATION, EVEN IF THE AUTHOR OR DISTRIBUTORS HAVE BEEN ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 *
 * THE AUTHOR AND DISTRIBUTORS SPECIFICALLY DISCLAIMS ANY WARRANTIES,
 * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
 * AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
 * ON AN "AS IS" BASIS, AND THE AUTHOR AND DISTRIBUTORS HAS NO OBLIGATIONS TO
 * PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 *
 */

Build like any other contrib. I.e. either:
 - untar in contrib folder of postgres source tree and do "make", "make install"
or
 - untar somewhere and do "USE_PGXS=1 make", "USE_PGXS=1 make install"

Currently only supports PostgreSQL 9.0 alpha.

Joe Conway
mail@joeconway.com


Example:

select * from unnest((select string_to_array(trim( both '''' from setting), ''' ''') from pg_config where name='CONFIGURE'));
                           unnest                            
-------------------------------------------------------------
 CFLAGS=-O0 -g3
 --prefix=/usr/local/pgsql-dev
 --with-pgport=65432
 --with-perl
 --with-tcl
 --with-tclconfig=/usr/lib64
 --without-tk
 --enable-nls
 --enable-debug
 --enable-cassert
 --enable-depend
 --with-pam
 --enable-thread-safety
 --with-openssl
 --with-krb5
 --with-includes=/usr/include/kerberosIV
 --with-includes=/usr/include/et
 --enable-integer-datetimes
 --with-libxml
 --with-python
 DOCBOOKSTYLE=/usr/share/sgml/docbook/dsssl-stylesheets-1.79
(21 rows)