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 по дате отправления
От: jian he
Дата:
От: PG Doc comments form
Дата:
FAQ