Re: Accessing pg_controldata information from SQL - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Accessing pg_controldata information from SQL
Date
Msg-id 200906021419.n52EJCC12205@momjian.us
Whole thread Raw
In response to Accessing pg_controldata information from SQL  ("Massa, Harald Armin" <chef@ghum.de>)
Responses Re: Accessing pg_controldata information from SQL
List pgsql-general
Massa, Harald Armin wrote:
> Hello,
>
> is there any way to acess the pg_controldata information via SQL?
>
> (running pg_controldata via shell needs file access to the postgresql data
> dictionary, which is usually not given)

Some of the settings have read-only variables that appear in SHOW ALL or
the pg_settings tables, or SELECT version().  Is there something
specific you are looking for that doesn't appear there?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: "Carlos Oliva"
Date:
Subject: Schema, databse, or tables in different system folder
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: is generate_series_timestamp() exposed on public api ?