Generate a UUID in Postgres

Question

My tables make use of UUID values. I am inserting rows using SQL SQLWorkbench/J but I don't see how I can generate UUIDs when performing a SQL INSERT INTO (-want-to-generate-uuid-here, '5', 'some value'). Is there a way to generate UUIDs with SQLWorkBench/J?

Thanks

For full and varied answers on generating UUID in PostgreSQL, see: https://stackoverflow.com/q/12505158/6710366 — André Carvalho, May 27 '22 at 17:03
Does this answer your question? [Generating a UUID in Postgres for Insert statement?](https://stackoverflow.com/questions/12505158/generating-a-uuid-in-postgres-for-insert-statement) — André Carvalho, May 27 '22 at 17:06

score 8 · Accepted Answer · edited Apr 28 '21 at 05:58

8

Use

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

then you can use uuid_generate_v4().

edited Apr 28 '21 at 05:58

Laurenz Albe

209,280
17
206
263

answered Apr 28 '21 at 04:23

friartuck

2,954
4
33
67

4

With Postgres 13 you don't need the extension any more – Apr 28 '21 at 05:04
7

You can use `gen_random_uuid ()` since PG13 without needing the `uuid-ossp` extension – Svetlin Zarev Apr 28 '21 at 06:12
@SvetlinZarev your comment should be an answer. – Pepe Alvarez Feb 02 '23 at 00:56

score 3 · Answer 2 · answered Feb 02 '23 at 07:31

3

Since Postgres 13, UUIDs can be geneerated with gen_random_uuid () without needing the uuid-ossp extension

answered Feb 02 '23 at 07:31

Svetlin Zarev

14,713
4
53
82

Generate a UUID in Postgres

2 Answers2