Date: Wed, 1 Sep 2021 16:12:37 -0400
From: Bruce Momjian <bruce@momjian.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: Error in sql script
Message-ID: <20210901201237.GC24833@momjian.us>
References: <163042968236.701.8405099741064036121@wrigleys.postgresql.org>
 <CAKFQuwY81AA_tvZ5T5b+L3Bj9eQ2j2s2Gr6go6Sg5crqUJmyOw@mail.gmail.com>
 <CAEfU0ipExs4-MCS0LwM_A5U8L4VAmPPFz60B38mbAmmmPStZGQ@mail.gmail.com>
 <CAKFQuwYyY1Pm0Wuo0i5ber2t8km4wXX-+znZViC+6qqK3iUmaA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAKFQuwYyY1Pm0Wuo0i5ber2t8km4wXX-+znZViC+6qqK3iUmaA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20210901201237.GC24833%40momjian.us>
Precedence: bulk

On Tue, Aug 31, 2021 at 06:14:32PM -0700, David G. Johnston wrote:
> On Tuesday, August 31, 2021, Mathieu Decelles St-Pierre <
> mathieu.decelles.stpierre@gmail.com> wrote:
> 
>     So there is no SQL command that we can use to list the Text Search
>     Configurations on a system?
> 
> 
> There is…its not like psql has some special privilege to get that info from the
> server…
> 
> You can either get psql to show you the query it uses or lookup the available
> catalogs in the documentation and find the one that provides what you need.

If you run psql with -E, you will see the SQL queries used for the
backslash commands, and those queries can be run anywhere.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.