On Thu, May 31, 2018 at 11:47 AM, tango ward <tangowar...@gmail.com> wrote:
> 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.a...@cybertec.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 > > sorry, I should be following bottom-post.
