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 5 · Answer 1 · edited Apr 28 '21 at 05:58

5

Use

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

then you can use uuid_generate_v4().

edited Apr 28 '21 at 05:58

Laurenz Albe

167,868
16
137
184

answered Apr 28 '21 at 04:23

friartuck

2,624
2
28
55

4

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

You can use `gen_random_uuid ()` since PG13 without needing the `uuid-ossp` extension – Svetlin Zarev Apr 28 '21 at 06:12

Generate a UUID in Postgres

1 Answers1