Show creating extension before using - Mailing list pgsql-docs

From PG Doc comments form
Subject Show creating extension before using
Date
Msg-id 167025992034.1903.12704722974897092392@wrigleys.postgresql.org
Whole thread Raw
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/citext.html
Description:

On https://www.postgresql.org/docs/current/citext.html in "F.10.2. How to
Use It", it says "here's a simple example of usage" and begins by creating a
table with a `CITEXT` column.

For seasoned PostgreSQL users, it may be obvious that before running such an
example, one must `CREATE EXTENSION IF NOT EXISTS citext;`, but if a newer
user is told "use citext for this column" and given a link to this page,
nothing tells them how to enable it.

I suggest adding this instruction somewhere on this page, either in its own
section like "How to Enable It", or at the start of the "simple example", or
even at the end of the sentence near the top: "It can be installed by
non-superusers who have CREATE privilege on the current database by running
`CREATE EXTENSION IF NOT EXISTS citext;`."

pgsql-docs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: wiki postgresql Window_function some todo items is done?
Next
From: Jonathan Lemig
Date:
Subject: Fwd: Views "missing" from information_schema.view_table_usage