Re: Insert UUID GEN 4 Value

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