Re: Insert UUID GEN 4 Value - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Insert UUID GEN 4 Value
Date
Msg-id ca7840e7-e6c2-0987-b80b-fa21a96e704e@aklaver.com
Whole thread Raw
In response to Re: Insert UUID GEN 4 Value  (tango ward <tangoward15@gmail.com>)
List pgsql-general
On 05/30/2018 09:45 PM, tango ward wrote:
> On Thu, May 31, 2018 at 12:06 PM, Rob Sargent <robjsargent@gmail.com 
> <mailto:robjsargent@gmail.com>> 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@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Insert UUID GEN 4 Value
Next
From: Ashu Pachauri
Date:
Subject: Re: Long running DDL statements blocking all queries