Re: Error in sql script

On Tue, Aug 31, 2021 at 06:14:32PM -0700, David G. Johnston wrote:
> On Tuesday, August 31, 2021, Mathieu Decelles St-Pierre <
> mathieu(dot)decelles(dot)stpierre(at)gmail(dot)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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

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