Thread: Error in sql script
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/textsearch-configuration.html Description: In /13/textsearch-configuration.html, the last script block starts with some incorrect characters and we do not see the sql command to list the Text Search Configurations.
On Tuesday, August 31, 2021, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/textsearch- configuration.html
Description:
In /13/textsearch-configuration.html, the last script block starts with some
incorrect characters and we do not see the sql command to list the Text
Search Configurations.
The last script relies upon the psql program and its exploratory meta-commands.
David J.
So there is no SQL command that we can use to list the Text Search Configurations on a system?
On Tue, Aug 31, 2021 at 3:22 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, August 31, 2021, PG Doc comments form <noreply@postgresql.org> wrote:The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/textsearch-configuration.html
Description:
In /13/textsearch-configuration.html, the last script block starts with some
incorrect characters and we do not see the sql command to list the Text
Search Configurations.The last script relies upon the psql program and its exploratory meta-commands.David J.
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.
David J.
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.