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
