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.