The table is defined with a primary key using an auto-increment column.
Example:
Code: Select all
CREATE TABLE tracker
(
tracking_id serial,
filename varchar(100),
)
Code: Select all
insert into public.tracker
(tracking_id,filename)
values (default,${tempchuScratch})
returning tracking_id;
Rick