gen_random_uuid is only available with pgcrypto enabled
От
PG Doc comments form
Тема
gen_random_uuid is only available with pgcrypto enabled
Дата
Msg-id
167456856827.2667301.17320033941826046414@wrigleys.postgresql.org
Список
Дерево обсуждения
gen_random_uuid is only available with pgcrypto enabled PG Doc comments form <noreply@postgresql.org>
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>
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 по дате отправления
От: PG Doc comments form
Дата: