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>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Error in sql script
Date: Wed, 1 Sep 2021 16:12:37 -0400
Message-ID: <20210901201237.GC24833@momjian.us> (raw)
In-Reply-To: <CAKFQuwYyY1Pm0Wuo0i5ber2t8km4wXX-+znZViC+6qqK3iUmaA@mail.gmail.com>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, david.g.johnston@gmail.com, mathieu.decelles.stpierre@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Error in sql script
In-Reply-To: <20210901201237.GC24833@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox