Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: gen_random_uuid is only available with pgcrypto enabled
Date
Msg-id CAKFQuwarXS0ygtxrr8RKJV2zyAM4ntnbd5opwEruWUOV=iBbbw@mail.gmail.com
Whole thread Raw
In response to gen_random_uuid is only available with pgcrypto enabled  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form <noreply@postgresql.org> wrote:
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.

But that isn't true...

postgres=# select * from pg_extension;
  oid  | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+---------+----------+--------------+----------------+------------+-----------+--------------
 12765 | plpgsql |       10 |           11 | f              | 1.0        |           |
(1 row)

postgres=# select gen_random_uuid();
           gen_random_uuid
--------------------------------------
 0a1be850-b1ae-48b9-bfe1-038df1e227f7
(1 row)

David J.

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: gen_random_uuid is only available with pgcrypto enabled
Next
From: "David G. Johnston"
Date:
Subject: Re: Naming of network_ops vs. inet_ops for SP-GIST