gen_random_uuid is only available with pgcrypto enabled - Mailing list pgsql-docs

From PG Doc comments form
Subject gen_random_uuid is only available with pgcrypto enabled
Date
Msg-id 167456856827.2667301.17320033941826046414@wrigleys.postgresql.org
Whole thread Raw
Responses Re: gen_random_uuid is only available with pgcrypto enabled  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: gen_random_uuid is only available with pgcrypto enabled  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/functions-uuid.html
Description:

Regarding the documentation on this page:
https://www.postgresql.org/docs/15/functions-uuid.html

It think the documentation should state clearly, that postgres natively does
not have any UUID generation functions. You can use the `pgcrypto` or
`uuid-ossp` extensions though:

    CREATE EXTENSION "pgcrypto"; /* enable pgcrypto extension */
    SELECT public.gen_random_uuid(); /* -> uuid */

See https://www.postgresql.org/docs/current/pgcrypto.html#id-1.11.7.37.11

    CREATE EXTENSION "uuid-ossp"; /* enable uuid-ossp extension */
    SELECT public.uuid_generate_v4(); /* -> uuid */

See https://www.postgresql.org/docs/current/uuid-ossp.html

pgsql-docs by date:

Previous
From: jian he
Date:
Subject: 9.7. Pattern Matching only a few links.
Next
From: PG Doc comments form
Date:
Subject: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/