Re: Insert UUID GEN 4 Value

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: tango ward <tangoward15(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Insert UUID GEN 4 Value
Date: 2018-05-31 04:06:38
Message-ID: 74277212-DEDF-4A35-B0BB-25A92088B2A1@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 30, 2018, at 9:57 PM, tango ward <tangoward15(at)gmail(dot)com> wrote:
>
>> On Thu, May 31, 2018 at 11:53 AM, tango ward <tangoward15(at)gmail(dot)com> wrote:
>>> On Thu, May 31, 2018 at 11:51 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>>> tango ward wrote:
>>> > I found this:
>>> >
>>> > CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
>>> > SELECT uuid_generate_v4();
>>> >
>>> > My problem is I have a table like this:
>>> > CREATE TABLE enrollmentinfo (
>>> > id integer NOT NULL,
>>> > created timestamp with time zone NOT NULL,
>>> > modified timestamp with time zone NOT NULL,
>>> > secure_id uuid NOT NULL,
>>> > relationship character varying(50) NOT NULL,
>>> > tuition_bill character varying(255) NOT NULL
>>> > );
>>> >
>>> > Now I need to insert data into this table, I just don't know if I can use something like this
>>> > "INSERT INTO enrollmentinfo (current_timestamp, current_timestamp, uuid_generate_v4(), '', '');
>>> > I haven't tried this but also not sure if I can call the function inside INSERT.
>>>
>>> Why didn't you try it?
>>>
>>> I see no problem with that.
>>>
>>> Yours,
>>> Laurenz Albe
>>> --
>>> Cybertec | https://www.cybertec-postgresql.com
>>>
>>
>>
>> Okay I will try it.
>
> When I tried it, I am getting an error: Invalid input syntax for UUID: uuid_generate_v4(),
What do you get from
Select uuid_generate_v4();

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-05-31 04:18:44 Re: Insert UUID GEN 4 Value
Previous Message tango ward 2018-05-31 03:57:13 Re: Insert UUID GEN 4 Value