On Thu, May 31, 2018 at 12:45 AM, tango ward <tangowar...@gmail.com> wrote:
> On Thu, May 31, 2018 at 12:06 PM, Rob Sargent <robjsarg...@gmail.com> > wrote: > >> >> >> On May 30, 2018, at 9:57 PM, tango ward <tangowar...@gmail.com> wrote: >> >> 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(), >> >> What do you get from >> Select uuid_generate_v4(); >> > > If I try these in psql, CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; SELECT > uuid_generate_v4(); > > I am getting the generated code but I dunno how to use this in INSERT > statement. I am getting an error of invalid input systex for UUID. > Hello, Using INSERT (..) VALUES (..) won't execute functions. It expects literal values. Instead do something like INSERT INTO enrollmentinfo (id, created, modified, secure_id, relationship, tuition_bill) SELECT your_id_returning_function_or_a_literal_value(), current_timestamp, current_timestamp, uuid_generate_v4(), 'some relationship', 'some tuition bill text'; ...modified with real values, of course... That should get you over the hump. Good luck on your project! CG
