pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedError in sql script
5+ messages / 4 participants
[nested] [flat]
* Error in sql script
@ 2021-08-31 17:08 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Doc comments form @ 2021-08-31 17:08 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: mathieu.decelles.stpierre@gmail.com
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Error in sql script
@ 2021-08-31 19:22 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2021-08-31 19:22 UTC (permalink / raw)
To: mathieu.decelles.stpierre@gmail.com <mathieu.decelles.stpierre@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Error in sql script
@ 2021-09-01 01:11 Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Mathieu Decelles St-Pierre @ 2021-09-01 01:11 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
So there is no SQL command that we can use to list the Text Search
Configurations on a system?
Mathieu
mathieu.decelles.stpierre@gmail.com
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.
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Error in sql script
@ 2021-09-01 01:14 David G. Johnston <david.g.johnston@gmail.com>
parent: Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2021-09-01 01:14 UTC (permalink / raw)
To: Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Error in sql script
@ 2021-09-01 20:12 Bruce Momjian <bruce@momjian.us>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2021-09-01 20:12 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-09-01 20:12 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-31 17:08 Error in sql script PG Doc comments form <noreply@postgresql.org>
2021-08-31 19:22 ` David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 01:11 ` Mathieu Decelles St-Pierre <mathieu.decelles.stpierre@gmail.com>
2021-09-01 01:14 ` David G. Johnston <david.g.johnston@gmail.com>
2021-09-01 20:12 ` Bruce Momjian <bruce@momjian.us>
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