Home > mailing lists

Insert UUID GEN 4 Value - Mailing list pgsql-general

From	tango ward
Subject	Insert UUID GEN 4 Value
Date	May 31, 2018 09:24:06
Msg-id	CAA6wQLK1MLj6gL9wQYLNZD541_xJjbv9X5EzVADOtMhQnifc9w@mail.gmail.com Whole thread Raw
Responses	Re: Insert UUID GEN 4 Value Re: Insert UUID GEN 4 Value
List	pgsql-general

Hi,

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.

Thanks,

From: George Neuner
Date: 31 May 2018, 06:45:27
Subject: Re: Pgagent is not reading pgpass file either in Windows or Linux.

From: Laurenz Albe
Date: 31 May 2018, 09:41:42
Subject: Re: Insert UUID GEN 4 Value