On Thu, May 31, 2018 at 11:53 AM, tango ward <tangowar...@gmail.com> wrote:
> 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. > When I tried it, I am getting an error: Invalid input syntax for UUID: uuid_generate_v4(),
