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.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.