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:47:44 |
Message-ID: | CAA6wQLJr6fjzx+ZK6N4yiViZYdFuGGkMT27zsp-mR1SjAzbGEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
thanks.
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.
On Thu, May 31, 2018 at 11:41 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> tango ward wrote:
> > I would like to know how to properly use uuid_generate_v4 when inserting
> data into PostgreSQL table.
> >
> > When I run the command select * from pg_available_extensions;
> > I can see this uuid-ossp | 1.0 |
> | generate universally unique identifiers (UUIDs)
> >
> > I am trying to find a basic and easy to understand documentation of it
> on how to use
> > when inserting data because I have a column that is a uuid type.
>
> Are you looking for this?
>
> ALTER TABLE tab ALTER col SET DEFAULT uuid_generate_v1();
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | tango ward | 2018-05-31 03:48:40 | Re: Insert UUID GEN 4 Value |
Previous Message | Laurenz Albe | 2018-05-31 03:41:42 | Re: Insert UUID GEN 4 Value |