Greg Smith wrote:
On 08/10/2011 02:46 PM, Geoffrey Myers wrote:
Is the max connections value in a system table somewhere?
If you intend to do anything with the value you probably want one of
these forms:
SELECT CAST(current_setting('max_connections') AS integer);
SELECT CAST(setting AS inte
2011/8/10, Greg Smith :
> On 08/10/2011 02:46 PM, Geoffrey Myers wrote:
>> Is the max connections value in a system table somewhere?
Yes, it is in the table "pg_catalog.pg_database". The column is named
"datconnlimit" and is of type "int4". See this:
http://www.postgresql.org/docs/9.0/interactive/
On 08/10/2011 02:46 PM, Geoffrey Myers wrote:
Is the max connections value in a system table somewhere?
If you intend to do anything with the value you probably want one of
these forms:
SELECT CAST(current_setting('max_connections') AS integer);
SELECT CAST(setting AS integer) FROM pg_settin
Is the max connections value in a system table somewhere?
Thanks.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
