Re: is max connections in a database table somewhere

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 integer) FROM pg_settings WHERE
> name='max_connections';
>
> The setting comes back as a text field when using current_setting on the
> pg_settings view (which isn't a real table, under the hood it's calling
> a system function)

Actually, just pulling it out of the database to display it in a report.


--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson