On Thu, May 31, 2018 at 11:51 AM, Laurenz Albe <laurenz.a...@cybertec.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.
