Project

General

Profile

1
ALTER TABLE ${table} ADD COLUMN ${idField} VARCHAR(2048) DEFAULT 'temp_'||md5(clock_timestamp()::text)||'_'||md5(random()::text);
2
CREATE INDEX ${table}_${idField}_idx ON ${table} (${idField});
(3-3/4)