Database Reference
In-Depth Information
True
# Immediately after
SELECT * FROM demo_insert;
id | name | phone
----+--------------+--------------------------------
1 | Harry Potter | {'44-234-0495', '44-234-9845'}
2 | Draco malfoy | {'44-234-4398'}
(2 rows)
# 30 seconds later
SELECT * FROM demo_insert;
id | name | phone
----+--------------+--------------------------------
1 | Harry Potter | {'44-234-0495', '44-234-9845'}
(1 rows)
# Insert a record with a timestamp far into the future
INSERT INTO demo_insert (id, name) VALUES ( 3, 'Ginevra
Weasley') USING TIMESTAMP 2147483647000000;
# Check the insertion timestamp
