Re: Insert UUID GEN 4 Value

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 05/30/2018 09:45 PM, tango ward wrote:
> On Thu, May 31, 2018 at 12:06 PM, Rob Sargent <robjsargent@xxxxxxxxx 
> <mailto:robjsargent@xxxxxxxxx>> wrote:

> If I try these in psql, CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; 
> SELECT uuid_generate_v4();
>
> I am getting the generated code but I dunno how to use this in INSERT 
> statement. I am getting an error of invalid input systex for UUID.

So please show what:

SELECT uuid_generate_v4();

is actually returning.

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx