Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Query the catalog - Mailing list pgsql-general

From Sibte Abbas
Subject Fwd: Query the catalog
Date
Msg-id bd6a35510708310533v164ce098v9771929369ac23f2@mail.gmail.com
Whole thread Raw
In response to Query the catalog  ("Ottó Havasvölgyi" <havasvolgyi.otto@gmail.com>)
List pgsql-general
Tree view


---------- Forwarded message ----------
From: Sibte Abbas <sibtay@gmail.com>
Date: Aug 31, 2007 8:32 AM
Subject: Re: [GENERAL] Query the catalog
To: Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>

On 8/31/07, Ottó Havasvölgyi <havasvolgyi.otto@gmail.com> wrote:
Hi,

How can I query the following information from the catalog:

You can find guc variables for both of these compile time constants:
 

- max number of index columns;

show  max_index_keys;

- max number of function arguments;

show max_function_args;
 

As far as I know these are compile-time constants, default is 32.

Thanks,
Otto


regards,
-- Sibte

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL with Kerberos and Active Directory
Next
From: Alban Hertroys
Date:
Subject: Obtaining random rows from a result set