From: | tango ward <tangoward15(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | "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 03:57:13 |
Message-ID: | CAA6wQLJ_tpazkwPOuO6yuqaVYaqDK0c1ZPkdp7vQtY0h6xm15Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(),
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2018-05-31 04:06:38 | Re: Insert UUID GEN 4 Value |
Previous Message | tango ward | 2018-05-31 03:53:16 | Re: Insert UUID GEN 4 Value |