Submit
Path:
~
/
/
usr
/
share
/
doc
/
postgresql-contrib
/
File Content:
moddatetime.example
DROP TABLE mdt; CREATE TABLE mdt ( id int4, idesc text, moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL ); CREATE TRIGGER mdt_moddatetime BEFORE UPDATE ON mdt FOR EACH ROW EXECUTE PROCEDURE moddatetime (moddate); INSERT INTO mdt VALUES (1, 'first'); INSERT INTO mdt VALUES (2, 'second'); INSERT INTO mdt VALUES (3, 'third'); SELECT * FROM mdt; UPDATE mdt SET id = 4 WHERE id = 1; UPDATE mdt SET id = 5 WHERE id = 2; UPDATE mdt SET id = 6 WHERE id = 3; SELECT * FROM mdt;
Edit
Rename
Chmod
Delete
FILE
FOLDER
Name
Size
Permission
Action
autoinc.example
798 bytes
0644
insert_username.example
560 bytes
0644
moddatetime.example
493 bytes
0644
refint.example
2105 bytes
0644
N4ST4R_ID | Naxtarrr