tango ward wrote:
> I would like to know how to properly use uuid_generate_v4 when inserting data into PostgreSQL table.
>
> When I run the command select * from pg_available_extensions;
> I can see this uuid-ossp | 1.0 | | generate universally unique identifiers (UUIDs)
>
> I am trying to find a basic and easy to understand documentation of it on how to use
> when inserting data because I have a column that is a uuid type.
Are you looking for this?
ALTER TABLE tab ALTER col SET DEFAULT uuid_generate_v1();
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com